Thursday, January 5, 2012

to repair a corrupted myisam table

first, to make sure the table not in use.

you may use the mysql client utility ready by mysql server installation "mysqlcheck" to do the repair 
sample command as follow:

shell> mysqlcheck -u <user_name> -p<password> --auto-repair <database_name> <table_name> &

No comments:

Post a Comment