check
mysqlcheck -c -u root -p --all-databases
单个table
use databasename ;
repair table tablename ;
http://www.51testing.com/?uid-166582-action-viewspace-itemid-133928
整个db
mysqlcheck -u root -p --auto-repair dbname
check
mysqlcheck -c -u root -p --all-databases
单个table
use databasename ;
repair table tablename ;
http://www.51testing.com/?uid-166582-action-viewspace-itemid-133928
整个db
mysqlcheck -u root -p --auto-repair dbname