Collections:
Repair MyISAM Tables in MySQL
How To Check and Repair MyISAM Tables in MySQL?
✍: FYIcenter.com
If you have a corrupted MyISAM table, like the one resulted from the previous tutorial exercise, you can use the "CHECK TABLE" and "REPAIR TABLE" commands to try to repair it. The following tutorial exercise gives you a good example of repairing a corrupted MyISAM table. Luckily, the table is repaired successfully:
>\mysql\bin\mysql -u dev -piyf fyi mysql> CHECK TABLE fyi_isam; +--------------+-------+----------+------------------------- | Table | Op | Msg_type | Msg_text +--------------+-------+----------+------------------------- | fyi.fyi_isam | check | error | Record at pos: 0 is not remove-marked | fyi.fyi_isam | check | error | record delete-link-chain corrupted | fyi.fyi_isam | check | error | Corrupt +--------------+-------+----------+------------------------- 3 rows in set (0.01 sec) mysql> REPAIR TABLE fyi_isam; +--------------+--------+----------+------------------------ | Table | Op | Msg_type | Msg_text +--------------+--------+----------+------------------------ | fyi.fyi_isam | repair | warning | Number of rows changed from 1 to 2 | fyi.fyi_isam | repair | status | OK +--------------+--------+----------+------------------------ 2 rows in set (0.47 sec) mysql> SELECT * FROM fyi_isam; +----+-------+-------+ | id | title | count | +----+-------+-------+ | -1 | NULL | NULL | | -2 | NULL | 987 | +----+-------+-------+ 2 rows in set (0.00 sec)
⇒ Tables Using InnoDB Storage Engine in MySQL
⇐ Restore Tables by Copying MyISAM Files in MySQL
2017-09-01, 1626🔥, 0💬
Popular Posts:
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...