How can we repair a MySQL table?

How can we repair a MySQL table?

How can we repair a MySQL table?

View Answers

November 13, 2010 at 3:39 PM

Hi,

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.

Thanks









Related Tutorials/Questions & Answers:
How can we repair a MySQL table?
repair a MySQL table.
Advertisements
How can we create a database using PHP and mysql?
ModuleNotFoundError: No module named 'tableh'
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?
ModuleNotFoundError: No module named 'tabler'
ModuleNotFoundError: No module named 'tabler'
Different tables present in MySQL
how can i hide and show tables
Data fetch from multiple SQL tables - Hibernate
Mysql List Tables
ModuleNotFoundError: No module named 'django-tabler'
mysql select from multiple tables
How can we destroy the cookie?
Create Database and tables in MySQL
Mysql List Tables
ModuleNotFoundError: No module named 'tablet'
mysql tables - JDBC
Learn how to take MySQL Backups and restore the same.
How can we register the variables into a session?
How can we know that a session is started or not?
How we can create a table through procedure ?
how can we store the encrypted passwaord in swings?
How can we destroy the session, how can we unset the variable of a session?
how we can create website through java
How can we get hibernate statistics?
How can I show users privileges in MySQL?
How can we save a data list in jsf?
Purge Data from Mysql tables
How to copy existing column along with data and column name into another existing table
How can we solve this puzzle using java ?
Mysql Join 3 Tables
how to set the tables one is left and another one is right - JSP-Servlet
How many ways we can give the output to a browser?
How can we encrypt the username and password using PHP?
How can we submit a form without a submit button?
How can we increase the execution time of a php script?
how can we prevent back option after log out.
How can we know the count/number of elements of an array?
what is cloud computing? any how we can implement?
ModuleNotFoundError: No module named 'encoding_repair'
ModuleNotFoundError: No module named 'geojson-repair'
How many ways can we get the value of current session id?
How can we get second of the current time using date function?

Ads