Repaire corrupted MyISAM tables

| No Comments | No TrackBacks

To repare the corrupted MyISAM tables, just cd to the directory that holds the MyISAM datafiles, then run this:

$ myisamchk -r -q table_name

If it doesn't work, try this command,

$ myisamchk --safe-recover table_name

The above two commands can fix most of the problems of MyISAM tables.

No TrackBacks

TrackBack URL: http://www.yinfor.com/mtcgi/mt-t-1202.cgi/2079

Leave a comment

About this Entry

This page contains a single entry by David Yin published on February 17, 2008 9:38 PM.

MySQL Backup and Recovery Methodologies was the previous entry in this blog.

Stop cron emails at Dreamhost is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.

OpenID accepted here Learn more about OpenID
Powered by Movable Type 4.26

Subscribe

Online Tools