mysqldump: error 29 - TEMP SOLUTION

Home Training and Tutorials mysqldump: error 29 – TEMP SOLUTION

May 23, 2009

On MYSQL DB with LOTS of tables, you might run into an error with ‘mysqldump’:

mysqldump: Got error: 29: File …..

Solution:

Add –skip-lock-tables to your command

System: CentOS 64bit with MySQL 5.0.45-log