Mysql error

[jdpravin]

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?

[madaboutlinux]

Is Mysql service down? Try to repair the database from the command prompt using the following command:

myisamchk -r /var/lib/mysql//username_dbname/*.MYI

restart the mysql service and see if the problem persists.

[nilesh_kolte]

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.