I found the bug report at
http://bugs.mysql.com/bug.php?id=26026
Adding --lock-all-tables as in
mysqldump --lock-all-tables --no-data etc.
solved the problem.
- Original Message -
From: Moon's Father
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Saturday, June 21, 2
Hi All,
I am running mysqldump with --no-data option, but it gives error:
"can't exec 'show fields from ...' out of resources when opening file ...
(errorcode 24) (23)"
perror 24 says: too many open files
perror 23 says: too many open files in system
mySQL show variables says: open_files_limit: 6