What and how to use MYISAMCHECK and MYSQLCHECK

Posted at August 4, 2016 at 4:32 pm by Jithin

MYISAMCHECK The default storage engine of the MySQL database is MyISAM. The myisam is vulnerable to corruption of the table. During the creation of table in MySQL it creates *.frm files to store table format, *.MYD (My Data) file to store the data and *.MYI (My Index) to store the index.   1) Checking all corrupted tables. myisamchk /var/lib/mysql/eximstats/*.MYI myisamchk: error: Wrong bytesec: 0-0-0 at linkstart: 24569875 MyISAM-table '/var/lib/mysql/eximstats/error1.MYI'    [...]

Read More