Yesterday when the backend program read the database information, the Log Report related data table can not read and write data, into the MySQL database found table './wordpress/wp_posts ' is marked as crashed and should be repaired Error because the data table in the Qqtexas is corrupted, so the data cannot be read:
# mysql-u Root-penter password:mysql> use Qqtexas; Reading table information for completion of table and column namesyou can turn off this feature to get a quicker startup W Ith-adatabase changedmysql> SELECT * from Wp_posts; ERROR 145 (HY000): Table './wordpress/wp_posts ' is marked as crashed and should be repairedmysql> quit
Method One:
Fix MySQL Database data table problem can be solved by Mysqlcheck, first with Mysqlcheck to look at:
# mysqlcheck-u root-p qqtexasenter Password:
Then add the--auto-repair parameter automatic repair, preferably before repairing backup database:
# mysqldump -u root -p qqtexas > qqtexas.sqlenter password:# Mysqlcheck -u root -p qqtexas --auto-repairenter password:wordpress.wp_term_ taxonomyerror : table upgrade required. please do "REPAIR TABLE ' wp_term_taxonomy ' " or dump/reload to fix it!wordpress.wp_termserror : Table upgrade required. Please do "repair table ' Wp_terms ' or dump/reload to fix it!wordpress.wp_usermetaerror : Table upgrade required. Please do "repair table ' Wp_ Usermeta ' " OR DUMP/RELOAD TO FIX IT!WORDPRESS.WP_USERSERROR    : Table upgrade required. Please do "repair table ' wp_users '" or dump/reload to fix it! repairing tablesqqtexas.wp_commentmeta OKqqtexas.wp_comments OKqqtexas.wp_links OKqqtexas.wp_options okqqtexas.wp_postmeta ok
For security reasons, the following two methods are not recommended for use in a production environment
#mysqlcheck-A-o-r-p//check to optimize and repair all databases
#mysqlcheck-A-o-r database name-p//repair the specified database
Parameter implication:
-A = analyse given tables. Analysis Data Sheet
-c = Check table for errors//check database for errors (corrupted) tables
-O = optimise table//optimized data table
-r = Can fix almost anything except unique keys that aren ' t unique//repair corrupted data table
-M =–medium-check
Method Two:
Repairing a database's myi file using the command Myisamchk
[Email protected] ~]# myisamchk-c-r/usr/local/mysql/data/qqtexas/zt_action. Myi-recovering (with sort) myisam-table '/usr/local/mysql/data/qqtexas/zt_action. MYI ' Data records:21810-fixing index 1-fixing index 2
If this does not work, use-f to enforce the fix;
Myisamchk-c-r-f/usr/local/mysql/data/qqtexas/zt_action. MYI
Mysqlcheck Description:
The Mysqlcheck client can examine and repair the MyISAM table. It can also optimize and analyze tables.
The Mysqlcheck function is similar to MYISAMCHK, but its work is different. The main difference is that when the MYSQLD server is running, Mysqlcheck must be used, and myisamchk is applied to the service
The service does not run. The advantage of using Mysqlcheck is that you do not need to stop the server to check or repair the table. Failure to use MYISAMCHK repair is irreversible.
Mysqlcheck provides a convenient way for users to check table, REPAIR table, ANALYZE table, and optimize table using SQL statements. It determines
Use which statement is used in the action you want to perform, and then send the statement to the server you want to execute.
Reference: http://www.vpsee.com/
Http://www.cnblogs.com/zhoujinyi/archive/2013/05/10/3070667.html
Http://www.javatang.com/archives/category/database
This article is from the "Start from the Heart" blog, please be sure to keep this source http://hao360.blog.51cto.com/5820068/1636856
Troubleshoot MySQL Table ' * * * * marked as crashed and should be repaired issues