Repaire corrupted MyISAM tables

By David Yin on February 17, 2008 9:38 PM | | Comments (0) | TrackBacks (0)

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.


Categories

L.A.M.P.

Tags

Related Entries

0 TrackBacks

Listed below are links to blogs that reference this entry: Repaire corrupted MyISAM tables.

TrackBack URL for this entry: http://www.yinfor.com/mtcgi/mt-tb-trackback.cgi/2079

Leave a comment

Earn $$ with WidgetBucks!
Earn $$ with Bidvertiser!
DreamHost!
Sponsored Review!

Surprising Sites


Online Tools

Code Convertor
GeoURL Bloggerwave BlogCatalog
Listed on BlogShares
Locations of visitors to this page
Technology Blogs - Blog Top Sites

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.

Categories