How to repair your MySQL databases

If you are using MySQL databases as your database engine, you surely ever get the error message as below if your database grown day by day.

Table “table” is marked as crashed and should be repaired.

To understand MySQL database table with MyISAM type, you will have .frm, .MYI and .MYD type, so the data stored from MyISAM type is storing to .MYI file extension.

To repair the database, open your SSH Console, type the following command.

myisamchk -o /path_to_mysql/database_name/table_name.MYI

where the table_name is the table name.

If you got tmp drive too low, you may add the following command from the my.ini or my.cnf.

tmpdir = /home/mysql/tmp

assume you assign the path to /home/mysql/tmp/.

Your website shall working without any issue now.

Published by

Mick Genie

Mick Genie is the founder of and working at ExaBytes Network Sdn Bhd and WPWebHost web host company. He is expertise in Windows and Linux environment especially web hosting related information, tips and trick as well as the IT Information.

One thought on “How to repair your MySQL databases”

Comments are closed.