Error exporting MySQL database: Got error:145:table ' wp_options ' is marked as crashed and should being repaired when using LOCK tables solution

Mysqldump:got error:145:table ' wp_options ' is marked as crashed and should being repaired when using LOCK TABLES

The error is as shown above.

Today in to their own WP site, when the export data found not to come out, reported as the error, in the Internet to find a bit of information, said that this Zhang is marked with problems, need to optimize. Reference:

Http://www.cnblogs.com/hakuci/archive/2012/03/20/2407723.html

Thanks to the information provided by Huang ' s blog, enter the MySQL bin directory and solve the problem successfully by following the command:

Myisamchk-c-R. /data/yourdatabasedir/wp_options. MYI

To export again:

Mysqldump-u root-p Air>air.sql

Under the current directory LS view, already has air.sql this file. Ok.

　　

　　

　

Error exporting MySQL database: Got error:145:table ' wp_options ' is marked as crashed and should being repaired when using LOCK tables solution