Processing of corrupted table or index files in mysql

If the table file or index file in mysql is corrupted, the error code 144,145 is displayed when you operate on the table. You can fix the error as follows:

(1) Use repair table table_name to modify the mysql command line;

(2) fix the problem in the program and execute repair table table_name to fix it. However, in this case, you need to pay attention to the issue. Do not execute SQL statements in the same connection as other SQL statements. Otherwise, other SQL statements may fail to be executed after the statement is executed.

You can re-open the connection before and after executing this statement (close_connection (); open_connection (); exec_ SQL (); close_connection (); open_connection. It is possible to re-open the connection after executing this statement, but this is not a test ).