MYISAMCHK is a table maintenance utility developed by MySQL. This utility works with MyISAM table that uses .MDI for index and .MYD for data. Database administrator can also use REPAIR Table & CHECK Table statements to repair and check corrupt MySQL database. It offers several options to check, repair and optimize corrupt MySQL database. The options are given below:
Friday, January 13, 2012
Friday, January 6, 2012
Performing backup of MySQL database is the most important activity of any database administrator but most of database administrators just neglect this activity. It is like a nightmare situation for the administrators, if database gets corrupt and there is no any backup available to recover MySQL database. At this scenario, they will realize that they have done a blunder mistake. Backup helps to handle any type of corruption strike by virus, hardware failure and other.