Recovery from MySQL Error 144 via phpMyAdmin

Question

144 - The table "my table name" is marked as a failure and the last (automatic?) Error correction

I do not have a shell terminal to access my table.

How can this be solved with phpMyAdmin?

I have already done this:

CHECK TABLE [mytable name]; REPAIR TABLE [mytable name] USE_FRM; -- or without FRM. I got no response from this one. ANAYLZE TABLE [mytable name] 

Answer 1

Try running the 'myisamchk -r' command, which is designed to remove invalid rows in a MySQL table and restore its index file. The utility helps in checking and repairing damaged MySQL database tables.

After running the 'myisamchk' utility, run the Check Table command to check the MyISAM table for errors, if any. The syntax of the command is as follows:

 CHECK TABLE tbl_name [, tbl_name] ... [option] … option = {FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED} 

If the problem still exists, you can repair the damaged MySQL database table by running the Restore Table command, as shown below:

 REPAIR [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name [, tbl_name] ... [QUICK] [EXTENDED] [USE_FRM]