X

Checking for corrupt, not cleanly closed and upgrade needing tables

If you are seeing this issue it's very likely that the database server stopped working abruptly. This can mean an issue with your current web hosting provider!

You should try our hosting and never have these issues.

With our managed shared hosting we would fix these types of issues completely free!

Wondered why sometimes you might see the following MySQL message?

Checking for corrupt, not cleanly closed and upgrade needing tables

In most cases this is not an error. It's only a system notification telling you that MySQL server is checking the tables during the start-up process. However, if your tables were not cleanly closed, you might need to run these commands from shell:

For not cleanly closed MyISAM tables

Check table(s):

myisamchk /path_to_mysql/db1.MYI

You can put an asterisk (*) to check all tables.

Repair table(s):

myisamchk –recover /path_to_mysql/db1.MYI
or with –safe-recover instead of –recover

SQL statements

In addition, there are some SQL statements for MyISAM and InnoDB tables that can help you with corrupt tables. These are:

CHECK TABLE_NAME

REPAIR TABLE_NAME

Categories: Articles
wpwpadmin:
Related Post