Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL keeps failing

Discussion in 'General Discussion' started by beashnet, Apr 6, 2003.

  1. beashnet

    beashnet Member

    Joined:
    Feb 21, 2003
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    151
    MySQL keeps failing(URGENT)

    Hey!

    MySQL keeps failing. Running WHM 6.2.0 Cpanel 6.2.0-R55 RedHat 7.3. It worked fine after the update so it's not that.
    Running MySQL 3.x according to WHM. It didnt update to MySQL 4 like for everyone else.

    Here's the error I found in the err log for my hostname in /var/lib/mysql :

    030407 01:21:20 mysqld started
    InnoDB: Error: auto-extending data file ./ibdata1 is of a different size
    InnoDB: 512 pages (rounded down to MB) than specified in the .cnf file:
    InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages!
    InnoDB: Could not open data files
    030407 1:21:20 Can't init databases
    030407 1:21:20 Aborting

    030407 1:21:20 InnoDB: Warning: shutting down a not properly started
    InnoDB: or created database!
    030407 1:21:20 /usr/sbin/mysqld: Shutdown Complete

    030407 01:21:20 mysqld ended
    030407 01:21:20 mysqld ended


    Any ideas? Would appreciate help asap since I have some live sites on the box.
     
    #1 beashnet, Apr 6, 2003
    Last edited: Apr 7, 2003
  2. beashnet

    beashnet Member

    Joined:
    Feb 21, 2003
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    151
    Fixed.

    I removed the 'ibdata1' file and then did a restart of MySQL which created a new ibdata file along with other relevant files.

    Cheers
     
  3. FusionBiz

    FusionBiz Member

    Joined:
    Sep 17, 2002
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    151
    Try to reboot your server might be able to resolve the problem if not search for the forum and you will be able to find a solution :)

    cPanel.net Support Ticket Number:
     
  4. perlchild

    perlchild Well-Known Member

    Joined:
    Sep 1, 2002
    Messages:
    279
    Likes Received:
    0
    Trophy Points:
    166
    You might instead use
    skip-innodb
    skip-bdb

    if you don't use those mysql table handlers(innodb and bdb)

    cPanel.net Support Ticket Number:
     
Loading...

Share This Page