Friday, November 14, 2008

MySQL recovery

If your MyISAM tables ever get screwed, use this procedure

1. stop mysql
2. go to mysql data folder (typically /var/lib/mysql)
3. run "myisamchk -r -f -s -u *.MYI"
4. restart mysql

No comments:

Post a Comment