How to repair MySQL table

Created:

2016-11-16 12:46:12 UTC

Modified:

2017-05-09 11:02:05 UTC

0

Was this article helpful?


Have more questions?

Submit a request

How to repair MySQL table

Applicable to:

  • Plesk

Symptoms

Error is reported in Plesk control panel when domains/customers are managed:

    Table './psa/exp_event' is marked as crashed and should be repaired

Resolution

  1. Run mysqlcheck command to check and fix Plesk database table reported in error message:

    For Linux:

    mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow` -r psa exp_event

    For Windows:

    "%plesk_dir%\\MySQL\\bin\\mysqlcheck" -P8306 -uadmin -p"plesk_admin_password" -r psa exp_event
  2. From MySQL console:

    mysql> REPAIR TABLE <table name>;
  3. Using SQL Webadmin , select table and choose action - Repair table .

Note: Not all tables in Plesk database support repair:

    The storage engine for the table doesn't support repair

In such case, follow instructions provided in article \#213939865 .

Have more questions? Submit a request
Please sign in to leave a comment.