I can not backup my databases by using myslqdump, here's the message:
# Error: Unknown table engine 'PERFORMANCE_SCHEMA', inpossible to LOCK TABLE
This error-message doesn't disappear, also after we've restarted the service 🙁
Our dumped file seems to be corrupted in some way…
Best Answer
This error seems to be related to the MySQL-Bug #58406 (status: verified).
For the moment, you can ignore that message. The process skips the table and continues as always.
Whatever, if you want to make sure that your database has not been corrupted in consequence of this error, simply force
mysqldump
to ignore all performance_schema-tables:Parallels Plesk Panel:
Default method: