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.

 

Hm0dIolPJUj6S6Cq70eK

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.

PFOph42MzoAllF7xXFKABgoGYpiJzPOibtBzpUt76 uKZQZO3sp86z 0dvmXvDyUJQHe5nO3y1fgdypt8S6we B8uI hXhqZe qk6qHnItJ8YKQyhDfHlBIPrMZYU AaZBho5lf

 

Share via
Copy link