How to Optimize & Repair MySQL Database tables using phpMyAdmin in cPanel?

Optimize and Repair tables using phpMyAdmin in cPanel

This article is about optimizing and repairing MySQL database tables using phpMyAdmin in cPanel. A website with high traffic and a large amount of content may have a very large database so a periodic optimization may help to improve the performance of the website.

For optimizing and repairing tables using phpMyAdmin, find the below steps

Step 1: Login to cPanel.

Step 2: Go to Database Section and select phpMyAdmin.

Step 3: Redirected to phpMyAdmin dashboard and select the particular database on the left pane.

Step 4: The tables available in the database will be displayed and then select the List box under the tables.

Step 5: Select the action required in the List Box and repeat it for repair the table.

Step 6: The necessary action will be taken and the message will be displayed.

Step 1 Login to cPanel.

Step 2 Go to Database Section and select phpMyAdmin.

Select phpMyAdmin

Step 3 You will be redirected to phpMyAdmin dashboard and select the particular database in the left pane.

Select the Database

Step 4 It will display the available tables in the database along with the option. Select the List box under the tables.

List of Options

Note: Scroll down the page to view the list box.

Step 5 Select the action required in the List Box. Repeat the step for repair the table.

Select the required option with table

Note: Table must be select to perform on it.

Step 6 The necessary action will be taken and then the message will be shown.

The Successful Message

Step 7 Done!

Video Tutorials