LiveChat 
Support 
Why & How to Optimise & Repair MySQL Database using phpMyAdmin in cPanel
In this article will understand the way to optimize and repair MySQL Database using phpMyAdmin in cPanel.
Why Optimise and Repair MySQL Database?
Before moving further on the method of optimizing and repairing the MySQL database allow us to perceive why it’s necessary to do so:
1. Databases develop to a substantial extent once a web site receives a lot of traffic and features a lot of data. As a result, it becomes important to optimize databases at regular periods to boost the site’s performance.
2. The records may be destroyed for a variety of reasons, as well as programming vulnerabilities, equipment problems, and even environmental disasters. In such things, you’ll be able to use phpMyAdmin to repair database tables.
Now, let us see the procedure:
1. Log in to the cPanel account.
2. After that select the Databases option and click on phpMyAdmin.
3. A new page of phpMyAdmin will get appear to you.
4. First of all from the left-hand side select the structure and you will be able to see a list of tables.
5. Now, looking on the operation you wish to carry out, choose the databases and put a tick mark in front of the names. You’ll be able to choose all at a time by selecting the “Check all” option.
6. Then you have to click on the drop-down arrow next to the tab “With selected”.
7. You will get a list of options. Choose “Optimize table” if you want to optimize the table and choose “Repair table” if you want to repair the table.
8. phpMyAdmin can allow you to apprehend whether or not or not the optimization and repair were successful. You’ll be able to see this as shown within the pictures given below.
This tutorial can show you the way to optimize and repair your MySQL database using phpMyAdmin in cPanel. Hopefully, you were ready to comprehend everything. Check out Ownwebservers Knowledge Base for a lot of helpful tutorials. We tend to even have an skilled team available to help you 24 hours day, seven days a week.