Applicable to:
- Plesk for Windows
- Plesk for Linux
Question
- How to repair non-InnoDB MySQL/MariaDB tables on Plesk server?
- How to repair website MySQL/MariaDB databases and tables in Plesk?
- How to repair domain MySQL/MariaDB databases and tables in Plesk?
Answer
-
Go to Domains > example.com > Databases and click Check and Repair for the required database
Linux-based operating systems:
-
Execute the below command substituting required table and database:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqlcheck <database name> <table name> --repair -u admin
Windows-based operating systems
-
Open command-line console
cmd.exewith Administrator privileges. -
Execute below command substituting required table and database:
MYSQL_WIN: C:>"%plesk_dir%MySQL\bin\mysqlcheck" -P3306 -uadmin -p -r <database name> <table name>
If the password is unknown, reset it according to this KB article.
Not all the storage engines in MySQL//MariaDB database support repair of the tables. If storage engine does not support repair the following message will appear:
CONFIG_TEXT: The storage engine for the table doesn't support repair
In such a case, follow the instructions provided in the article: How to fix InnoDB corruption cases for the MySQL database?
Comments
1 comment
Hi Benjamin Weßel,
May I ask how would you do so for all tables, or, how would you know which table to fix, and how to set it in the recommended CLI?
Please sign in to leave a comment.