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:
- Log in to cPanel or open phpMyAdmin directly if you already know how to do it.
- In the DATABASES section of the cPanel home screen, click phpMyAdmin:
The phpMyAdmin administration page will open in a new window.
- In the left sidebar, click the name of the database you want to work with. For instance, the image below shows the selected database named example_wordpress:
- In the right main window, select the checkboxes 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, select “With selected: 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 mighty small database administration software with nearly the same features as PHPMyAdmin. The significant 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 the website, you can immediately start using the adminer. 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:
Adminer may say that repairing is not possible if your database engine is InnoDB. In that case, select all database tables again and click on optimize.
That will recreate all database tables and is as helpful as repairing!