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
ModuleNotFoundError: No module named 'tableh'
How can we create a database using PHP and mysql?
ModuleNotFoundError: No module named 'tabler'
ModuleNotFoundError: No module named 'tabler'
Different tables present in MySQL
Data fetch from multiple SQL tables - Hibernate
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?
how can i hide and show tables
Mysql List Tables
ModuleNotFoundError: No module named 'django-tabler'
mysql select from multiple tables
Create Database and tables in MySQL
Mysql List Tables
ModuleNotFoundError: No module named 'tablet'
mysql tables - JDBC
How can we destroy the cookie?
Learn how to take MySQL Backups and restore the same.
Purge Data from Mysql tables
how can we store the encrypted passwaord in swings?
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 ?
Mysql Join 3 Tables
How to copy existing column along with data and column name into another existing table
How can I show users privileges in MySQL?
how we can create website through java
How can we get hibernate statistics?
How can we save a data list in jsf?
How can we destroy the session, how can we unset the variable of a session?
How can we solve this puzzle using java ?
how to set the tables one is left and another one is right - JSP-Servlet
ModuleNotFoundError: No module named 'encoding_repair'
ModuleNotFoundError: No module named 'geojson-repair'
Mysql Alter Tables
ModuleNotFoundError: No module named 'odoo11-addon-agreement-repair'
ModuleNotFoundError: No module named 'odoo11-addon-fieldservice-repair'
ModuleNotFoundError: No module named 'odoo11-addon-mrp-repair-refurbish'
ModuleNotFoundError: No module named 'odoo11-addon-mrp-repair-refurbish'
ModuleNotFoundError: No module named 'odoo12-addon-agreement-repair'
ModuleNotFoundError: No module named 'odoo12-addon-repair-calendar-view'
ModuleNotFoundError: No module named 'odoo12-addon-repair-calendar-view'
ModuleNotFoundError: No module named 'odoo13-addon-repair-refurbish'

Ads