Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Check and Repair MyISAM Tables
How To Check and Repair MyISAM Tables? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB
✍: 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)
2007-05-10, 4526👍, 0💬
Popular Posts:
How To Create an Add-to-NewsGator Button on Your Website? - RSS FAQs - Adding Your Feeds to RSS News...
What Are Data Pump Export and Import Modes? - Oracle DBA FAQ - Loading and Exporting Data Data pump ...
How To Increment Dates by 1? - MySQL FAQs - Introduction to SQL Date and Time Handling If you have a...
If cookies are not enabled at browser end does form Authentication work? No, it does not work.
How To Run Stored Procedures in Debug Mode? - Oracle DBA FAQ - Introduction to Oracle SQL Developer ...