Contact Support : +64 220 256 070

Aimvm
Blog

How to repair and optimize a Mysql Database?

Posted on: October 15, 2014

This lesson will teach you on repairing and optimizing a Mysql database on the server. Before repairing and optimizing the database, we suggest you to keep a backup of that database.

Steps:

1) Login to the server WHM.

2) Open PHPMyadmin option.

3) Select the database you want to perform repair and optimize.

4) Check all the tables and from the drop down option select ‘repair’.

j3

 

Now you have repaired all the tables in the selected database.

5) Check all the tables and from the drop down option select ‘optimize’.

j4

Now you have repaired and optimized the Mysql database. If you encounter any issues during this process, you can open a support ticket with us.

 

 

 

Search Blog