• Mysql

mysqldump: Got error: 1017: Can’t find file: ‘wp_wfBadLeechers’ (errno: 2) when using LOCK TABLES

By PrasadNaik

July 20, 2017

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.