I'm using mysqlhotcopy to write a little backup script. The problem is if there are a lot of tables, mysqlhotcopy exits with error 24, which means too many files open.
From my understanding, mysqlhotcopy locks each table, therefore has to open each file to do so and all the file descriptors are used (in my case).
Has anyone had this problem and do you have a solution? I'll probably just end up using mysqldump but it would be nice to see if someone has a workaround.