MySQL Dump fails

MySQL Dump fails

von T K -
Anzahl Antworten: 2

Hi All,

I am using Moodle 3.4 mysql 5.6.40

I noticed that the mysqldump fails with the below error:

mysqldump: Got error: 1146: Table 'aicb_prod.mdl_tag_correlation' doesn't exist when using LOCK TABLES


I checked into the mysql DB, there is mdl_tag_correlation table, but it is empty. It does not contain any data at all. Would it be fine to just delete it?


Thanks!

Mittelwert: -
Als Antwort auf T K

Re: MySQL Dump fails

von Davo Smith -
Nutzerbild von Core developers Nutzerbild von Particularly helpful Moodlers Nutzerbild von Peer reviewers Nutzerbild von Plugin developers
No, you can't just delete arbitrary tables from the Moodle database and expect it to keep working. You may not have any data written to that table, but that doesn't mean that there aren't queries that will access that table to see if there are any matching records there (which will fail with an error message if the table is missing).

I'm afraid I can't really help with the original error, but it does sound like something has gone wrong with your database configuration or data, as it doesn't sound like the sort of situation that should normally be able to occur.
Mittelwert: -
Als Antwort auf T K

Re: MySQL Dump fails

von Benjamin Ellis -
Nutzerbild von Particularly helpful Moodlers
Hi,

Try running 'mysqlcheck -u mysql_username -p aicb_prod' on your database - it may have been corrupted. Failing that, it appears that deleting - suggest you move it instead - the mdl_tag_correlation.frm file should resolve the issue. I would access the table in mysql before attempting to use mysqldump again.

Good Luck

Mittelwert: -