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 error

Discussion in 'Database Discussions' started by jdpravin, Dec 22, 2009.

  1. jdpravin

    jdpravin Registered

    Joined:
    Aug 23, 2004
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Hey,

    I'm seeing below error message in server mysql log

    ==========
    091222 13:27:57 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './username_dbname/products.frm
    =========

    my.cnf is like this

    ======

    [mysqld]
    set-variable = max_connections=750
    safe-show-database
    ==========

    And all sites are showing mysql errors

    Any help?
     
  2. madaboutlinux

    madaboutlinux Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    1,052
    Likes Received:
    2
    Trophy Points:
    38
    Location:
    Earth
    Is Mysql service down? Try to repair the database from the command prompt using the following command:

    restart the mysql service and see if the problem persists.
     
  3. nilesh_kolte

    nilesh_kolte Well-Known Member

    Joined:
    Apr 13, 2006
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Pune ,India
    cPanel Access Level:
    Root Administrator
    Hello,

    You can use the following commands to check the products table.

    1. Login to your mysql.
    mysql -u user -p pass

    2. Select the database
    mysql> user database;

    3. Run the following command to repair the table.

    mysql> repair table products

    4. It will show you the correct error.

    Also our friend "madaboutlinux" is given you one command that will also work.

    It's not related to your my.cnf. The problem is in your table variables.
     
Loading...

Share This Page