asked on

warning : 1 client is using or hasn't closed the table properly

Hi everyone,

Just a little bit of background on the situation. I moved my webserver from one physical box to another yesterday. I use a program called ISPConfig to administer the websites. I backed up all of the mysql stuff and put it onto the new server.

Now when I log onto the new server I get a message saying I have new mail. When I view the mail it says:

warning : 1 client is using or hasn't closed the table properly

About a few different databases. How can I fix it?

ifreq

One of your tables must been corrupted while moving them to another server, you can fix them with this command:

mysqlcheck -q -r -u root -p yourdatabasename

bswinnerton

ASKER

Is there a way to check all of them at once?

bswinnerton

ASKER

One of the databases came up with the following:

note : The storage engine for the table doesn't support repair

Is that something I should be concerned with?

ASKER CERTIFIED SOLUTION

ifreq

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Beverley Portlock

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ifreq

note : The storage engine for the table doesn't support repair

You propably have database which uses the InnoDB engine. It's very good engine but unfortunately not every provider offer the InnoDB support in MySQL and the support for InnoDB in MySQL is not perfect.

The InnoDB engine does not support the repair command, but AFAIK it is also not necessary.