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, 3424🔥, 0💬
Popular Posts:
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutoria...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...