MySQL corruption table fix

1. Recovery of the MYISAM table structure

If there is a. frm file but the myd,myi file is gone. Like only tab.frm.

1.1 Create an empty File tab. MYD tab. MYI note permissions, typically MySQL

1.2 Enter into the library, execute Repair table tab USE_FRM; Show OK

+-------------------------------------+--------+----------+----------+| Table | Op | Msg_type | Msg_text |+-------------------------------------+--------+----------+----------+| Wuxi_twns_db.transcoding_doing_task | Repair | Status | OK |+-------------------------------------+--------+----------+----------+

MySQL corruption table fix