Checking for corrupt, not cleanly closed and upgrade needing tables
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 notifying you that MySQL is checking the tables during the start up process. However, if your tables were not cleanly closed, you might need to run these commands:
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
If you would like a service but do not have enough of a budget, earn points through our affiliate program by referring customers to us and use them toward your project or service with us.
Have any questions?
Use the following form to submit them or call us at 917.558.8139 within US or +1 917 558 81 39 (International).
GEORGE
Sales & marketing
ALEX
Sales & marketing
GREG
Senior developer
Use the form below and ask your questions
