May 23, 2009

mysqldump: error 29 - TEMP SOLUTION

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

Click Here!