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:
    1
    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:
    1
    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:
    1
    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:
    16
    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