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, 4648👍, 0💬
Popular Posts:
How To Concatenate Two Character Strings? - MySQL FAQs - Introduction to SQL Basics If you want conc...
What's wrong with this initialization? char *p = malloc(10); My compiler is complaining about an ``i...
.NET INTERVIEW QUESTIONS - What is COM ? Microsoft’s COM is a technology for component software deve...
Which are the various programming approaches for WCF?
How To Set session.gc_divisor Properly? - PHP Script Tips - Understanding and Using Sessions As you ...