Backing up database via ssh

[Marc Smith]

Yesterday I upgraded and the forums are working OK. But, I have to change servers. I tried the usual:
***************************
SHIRLEY% mysqldump --opt -c -p -q -v forum > usr/local/etc/httpd/forum_bup-06-21.sq

Enter password:

# Connecting to localhost...

/usr/local/mysql/bin/mysqldump: Got error: 1017: Can't find file: './forum/userpromotion.frm' (errno: 24) when using LOCK TABLES
SHIRLEY%
**********************

Anyone have any idea what './forum/userpromotion.frm' is and what's happening? I can see the file if I ftp in so I know it's there.

[Steve Machol]

Error code 24: Too many open files

This is a server issue. Contact your host.