Database Backup Error: mysqldump: Got error: 1146: Table ‘enwei_hq.tb_classification’ doesn’t exist when using LOCK TABLES

The fixed script for regularly backing up the database has been running, but it is found that the database backed up in these two days is abnormal, the size is only 4.4m, the normal size is 64M, and the database backup is abnormal.

When the backup script is manually executed, there is an error message: mysqldump: got error: 1146: table ‘Enwei_hq.tb_classification’ doesn’t exist when using LOCK TABLES

Prompt database Enwei during backup_Table tb in HQ_Classification does not exist.

It is also possible for me to enter the database to view the table data, but I can’t view the specific contents in the table. The error report also means that it doesn’t exist

 

According to the query data prompt, you need to enter the directory of the database, find the table associated file, and then delete it

After deletion, I use the table data in the previously backed up database to recover, and then query the data. The display can be normal.

Then manually execute the database backup script. There is no error prompt. The backup database is 64M and the size is normal.

Similar Posts: