While making full backup of mysql using below command we got error
mysqldump: Got error: 1017: Can’t find file: ‘wp_wfBadLeechers’ (errno: 2) when using LOCK TABLES
# mysqldump –all-databases > /backup/all_databases.sql
The issue was due to some corrupt tables
Below is the fix used for making a full dump of database ignoring error
mysqldump –skip-lock-tables -f –all-databases > /backup/all_databases.sql
Mysql backup was completed ignoring the corrupt tables.