Online Hibernate Training just in Rs. 1000

One week online training in Hibernate ORM framework. Learn Hibernate Framework and enhance your skills. Best Online Hibernate training at 90% discount. Join Now!! Offer is valid Only for limited Period!!! Online Training Big Data and Hadoop Training Java Training  

How can we repair a MySQL table?



Share on Google+Share on Google+

How can we repair a MySQL table?
1 Answer(s)      6 years and 9 months ago
Posted in : PHP

How can we repair a MySQL table?

View Answers

November 13, 2010 at 3:39 PM


we can repair Mysql table using SQL statement with following staps:

  1. In the tree to the left, click on the hmailserver database. The hMailServer database will now be active.
  2. In the right part of the SQLyog window, click on the Query tab.
  3. Enter REPAIR TABLE tablename, for example, REPAIR TABLE hm_messages.
  4. Click on the Execute Current Query button in the toolbar (or select Edit->Execute Query->Execute current query or press F5).
  5. MySQL should now repair the table. After the table has been repaired, restart the MySQL and than the hMailServer service. Depending on what table is corrupt, a restart of the services may not be required, but we recommend that you always do it.



Related Tutorials/Questions & Answers: