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!

Mysql error

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

  1. jdpravin

    jdpravin Registered

    Joined:
    Aug 23, 2004
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    151
    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,051
    Likes Received:
    2
    Trophy Points:
    168
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. nilesh_kolte

    nilesh_kolte Well-Known Member

    Joined:
    Apr 13, 2006
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    156
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice