Repair and Optimize MySQL Databases with WebsitePanel

In this article I will explain how to repair and optimize MySQL databases with WebsitePanel.

Overview

Databases need maintenance from time to time. If you ever need to repair your database or just make it perform better, you need to know how to use the MySQL maintenance tools in WebsitePanel, which are very easy to use and won’t affect your applications. Let’s get started!

1. Log into WebsitePanel. Click on “Databases -> MySQL 5.x“:

mysql menu websitepanel arvixe

2. Select the database and click on Browse Database:

selecting mysql database websitepanel arvixe

3. You will be redirected to PHPMyAdmin, click on the database that you want to perform maintenance:

mysql database select websitepanel

4. Select all the tables in the database that you opened, then click on the combobox, and select the Repair table option:

repair table websitepanel mysql

5. Wait for the repair process to be executed, and that’s it:

repair successful mysql websitepanel

Optimize MySQL Databases Tables

6. In your PHPMyAdmin, click on the database selected:

selecting mysql database websitepanel arvixe

7. In the combobox, select Optimize table:

optimize databases mysql websitepanel

8. After completing the process, you will receive a successful message:

database optimized

9. And that’s it! The databases tables has been repaired and optimized.

This concludes Repair and Optimize MySQL databases with WebsitePanel.

Looking for quality ASP Web Hosting? Look no further than Arvixe Web Hosting!

Happy Hosting!

Rodolfo Hernandez

Tags: , , , , , , , , , , , , , , , , , | Posted under WebsitePanel Tutorials | RSS 2.0

Author Spotlight

Rodolfo Hernandez

Rodolfo Hernandez

I like photography and reading books. Currently working for Arvixe as Elgg Community Liaison. Elgg Security Expert Web Security Expert CEO of UDP SW Social Web

Leave a Reply

Your email address will not be published. Required fields are marked *


4 × = 8

You may use these HTML tags and attributes: <a href="" title="" rel=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>