Issue problem on one table => no database backup?

[sebgonzes]

Hello

On our servers, we have always an daily plesk backup incremental.
In some case, some tables of an database are corrupt (wordfence is dirty on this sometime) and seem that database backup fail :

Unable to make database dump. Error: Failed to exec mysqldump: Exit code: 2:
mysqldump: Got error: 1146: "Table 'bdd.wp_wfNet404s' doesn't exist" when using LOCK TABLES

Is there some way to "just" not backup this table but still have an backup of the other tables?

 

[IgorG]

mysqldump: Got error: 1146: "Table 'bdd.wp_wfNet404s' doesn't exist" when using LOCK TABLES

The database seems to be corrupt. It will be better to fix it with this KB article Dump of the MySQL database hosted on the Plesk server fails: mysqldump table doesn't exist when using LOCK TABLES

 

[sebgonzes]

The database seems to be corrupt. It will be better to fix it with this KB article Dump of the MySQL database hosted on the Plesk server fails: mysqldump table doesn't exist when using LOCK TABLES

Ok @IgorG but the question is, there is no way to ignore the corrupted table and dump all other? add some skip-lock-tables to plesk backup for example? it's really critical to have no dump of all tables of database for just one corupt table...

 

[IgorG]

There is no way to backup and restore the database partially. If for some reason the database cannot be correctly backed up, then the entire backup will fail.

 

[sebgonzes]

There is no way to backup and restore the database partially. If for some reason the database cannot be correctly backed up, then the entire backup will fail.

Ok for this point, other thing is that we not recieve in this case an backup fail message and only have an warning message in plesk backup utility, it's not easy to detect problem in case having a lot of server, is there some way to custom mail notificacion of error?