Mysql table is marked as crashed and last (automatic ?) Repai

Mysql table is marked as crashed and last (automatic ?) Repair failed solution 1. my colleague's server reported an error when backing up mysqldump. This is because the myisam table has too much data. At some point in time, the MyISAM table that stores data grows rapidly. for example, when the hard disk is full in some log tables. writing continues at this time. then the table will be locked; or the file tbl_name.MYI of the mysiam storage table will be damaged when you use phpmyadmin to open the database. the following fields in the MyISAM table are displayed in use.

Rows Type Collation Sizein use

 

When mysqldump is used for export, the error XXX table is marked as crashed and last (automatic?) is returned ?) Repair failed. 2. solution. find the folder in the mysql database. You can go to the mysql configuration file my. cnf (linux) my. find the datadir keyword in ini (windows), and find the corresponding database folder in the path. run the command in the database folder. <table_name> indicates the name of the table to be repaired,

# Myisamchk-r <table_name>

 

If this problem persists, stop mysql and

# Myisamchk-r-v-f <table_name>