The Plesk repair utility allows users to easily check and repair their Mysql database servers by verifying the integrity of their databases and database users. In this guide we’ll cover the steps necessary to check and repair your databases using the repair utility.
Repairing MySQL Databases with Plesk
To enable the Plesk repair utility, follow these steps:
- First, log in to your Plesk Onyx server as the root user, using your username and password.
- To check the availability of a MySQL database server and verify the integrity of its databases and users, use the command:
plesk repair mysql
- To check that a MySQL database server registered in Plesk is available and can be connected to, use the command:
plesk repair mysql -connection
- Lastly, you’ll want to check that all the MySQL database users created in Plesk exist on the database server as well. By using the following command, Plesk will check the database users’ privileges and correct them in case of discrepancies as well as recreating any database users that are missing. To do this, use the command:
plesk repair mysql -database-users
And there you have it!