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, 4604👍, 0💬
Popular Posts:
How will you freeze the requirement in this case? What will be your requirement satisfaction criteri...
How To Export Data to a CSV File? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you wan...
What print out will the folloging code produce? main() { char *p1=“name”; char *p2; p2=(char*)malloc...
Does there exist any other function which can be used to convert an integer or a float to a string? ...
What are different properties provided by Objectoriented systems ? Following are characteristic’s of...