Portal Home > Knowledgebase > MySQL and PostgreSQL > Optimization and repair of MySQL database


Optimization and repair of MySQL database




If you have suspicions that the MySQL database is running slowly or appear errors, you need to optimize and/or repair the database. This can be done through your control panel cPanel ---> phpMyAdmin

Steps to optimize and repair MySQL database:

  1. Log into your web hosting control panel cPanel
  2. Select the button phpMyAdmin
  3. After login to phpMyAdmin, on the left you’ll see the list of established databases. Click the one you want to optimize or repair
  4. After selecting the database you’ll see all the tables on the right side. Select the “Check all” link and mark all tables
  5. From the drop-down menu select the Optimize table/Repair table
  6. Then the page should be loaded in the list of all tables and have the status OK


Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read

* Minimum sign up periods for cPanel Web Hosting plans: Mini - 3mo., Pro - 1mo., Biz - 1mo., cPanel Reseller Hosting, Linux VPS, Windows VPS, Managed cPanel VPS and Dedicated Servers - 1mo. secret link
Accepted payments: Credit/Debit Card, Paypal, Payza, Skrill, WebMoney, CashU, Ukash, paysafecard, Bitcoin, Perfect Money, SolidTrust Pay, OKPay, EgoPay, Western Union/MG, Wire Transfer and more.