How to Repair or Optimize Database Tables?

Database tables crash from time to time. However, this can be prevented to the minimum by optimizing them. Here’s how you can repair and optimize the database table using phpMyAdmin.

Repair MySQL Database Tables

1. Open the phpMyAdmin tool.
2. Open the Databases tab.
3. Click on the name of the database to be repaired.
4. Select the tables that need repair by ticking the check-boxes on the left of the table names.
5. Use the With Selected: drop-down menu.
6. Choose Repair Table.

The tables will be automatically repaired and you will be presented with a page showing the results of the repair operation.

Optimize MySQL Database Tables

1. Select all of the tables that you want to be optimized by ticking the checkbox next to their name.
2. Use the With Selected: drop down menu
3. Choose Optimize table.

The optimization will be performed automatically and a new page will open that shows the result of the operation.

akshat,

Akshat is the Founder and CEO of BlogVault, MalCare, and WP Remote. These WordPress plugins, designed for complete website management, allows 100,000+ customers to build and manage high-performance websites with ease.