zeo

Some simple tips that you could do to your MySQL database on your own. I bet that some of you are afraid to touch your own databases. Let’s take a look at cPanel since it’s widely offered by most hosting company for control panel. We are going to repair and optimize your MySQL database from your cPanel.

Don’t be afraid to click Repair

There are 2 way to repair your MySQL databases from cPanel. First is from MySQL Account Maintenance and second from phpMyAdmin. If you are fimiliar with empty spaces or overhead in MySQL then this process should help you temporarily get rid of it.

From cPanel MySQL Account Maintenance

The easiest way is from cPanel MySQL Account Maintenance.

1. Log in to your cPanel.
2. To access the MySQL Account Maintenance Menu, click on the MySQL® Databases (the one with a cute dolphin icon) on the main screen of your cPanel interface.
3. You will be brought to MySQL Account Maintenance page.
4. Identify the database that you want to repair, then simply click Repair.

The long way using phpMyAdmin

The second method is from phpMyAdmin. From CPanel MySQL Account Maintenance, scroll down to the bottom and you’ll see a link to phpMyAdmin.

1. Once phpMyAdmin has loaded, select the database from the drop down menu on the left frame. Choose any database that you like to repair.
2. Once the requested database page is loaded, on the right frame you can select which table you want to repair. Tick all or either one of the table.
3. Then from the dropdown menu that says With Selected:, choose Repair Table. Optionally, you can also click Check tables having overhead.
4. A new page will load with bunch of OK. Your tables will be repaired once it’s is done.
5. From the dropdown menu you can also Optimize Table.

That’s it! You’re done.