Tag: MyISAM

Repaire corrupted MyISAM tables

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.

MySQL Backup and Recovery Methodologies

MySQL is very popular. Many open source or free software use MySQL as their main database engine. To make our data safe, please remember to backup your data regularly. There are two methodologies you can use to back up MySQL databases without spending money. The first is to create a series of SQL statements that