How to Repair mySQL Database with phpmyadmin and adminer

REPAIRING MYSQL DATABASES WITH PHPMYADMIN

If your website behaves strangely like throwing unknown errors or is not able to save settings permanently then it is likely that your database has become corrupted.

When this happens, you can try to repair database tables using one of the most popular database administration tools phpMyAdmin or adminer.

To repair MySQL database tables with phpMyAdmin, follow these:

  1. Log in to cPanel or open directly phpMyAdmin if you already know how to do it.
  2. In the DATABASES section of the cPanel home screen, click phpMyAdmin:

    The phpMyAdmin administration page will open in a new window
  3. In the left sidebar, click the name of the database that you want to work on. For instance, the image below shows the selected database named example_wordpress:
  4. In the right main window, select the check boxes for the tables in the database that you like to repair.
    To select all of the tables at once, select the checkbox Check All.

In the drop-down menu With selected:, select Repair table. phpMyAdmin then starts the repairing process and will let you know whether the repair process is successful or not.

REPAIRING MYSQL DATABASES WITH ADMINER

Adminer is a powerful small database administration software with nearly the same features as phpmyadmin. The big advantage is that this tool consists of only one single file which makes installing and using this tool extremely simple.

After uploading the adminer file to your website you can immediately start using it. Open it up in your web browser and log in to your database:

After logging in select the database you want to repair in the left pane:

In the main window select all database tables and then start the repairing process:

It may happen that adminer says that repairing is not possible if your database engine is InnoDB. In that case, select again all database tables and click on optimize.

This will recreate all database tables and is as helpful as repairing!

 

Leave a Reply

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