Unable to do backup

[grrlburn]

I have attempted to do a backup from the telnet prompt as recommended in the manual.

mysqldump --opt -uusername -p forums > /usr/home/username/usr/local/etc/httpd/htdocs/cherub/backups/100502.sql

but I get this error

/usr/local/mysql/bin/mysqldump: Got error: 1105: File '/usr/local/mysql-3.23.52/
var/forums/threadrate.MYD' not found (Errcode: 24) when using LOCK TABLES

Is my syntax wrong? Do I need to put my board in maintenance mode before I attempt this?

Christine

[George L]

try using

/usr/local/mysql/bin/mysqldump --opt -u mysqlusername -p forums > /usr/home/username/usr/local/etc/httpd/htdocs/cherub/backups/100502.sql

see what happens...

error 24 is too many files open, so i believ it's you mysql configuration

are you dedicated or shared hosted ? also what version of mysql are you using ?

[grrlburn]

I am on a virtual hosting machine, but I am currently the only customer on the box not that that matters. I am using mysql 3.23.52.

I tried the new syntax to no avail,k but I think I might have the path to mysqldump wrong, being on a virt server make things in places be weird.

So what should I change in my config file so I can run the normal command?

Thanks
Chris

[Steve Machol]

Don't change anything in config.php.

What is the latest error you are getting?

[grrlburn]

Hi Steve,

I didn't mean the config.php, I meant what should I change in the my.cnf file so I am not getting the Lock Tables error.
Here is the error I am getting

% /usr/home/username/usr/local/mysql/bin/mysqldump --opt -u mysqlroot -p forums > /usr/home/username/usr/local
/etc/httpd/htdocs/cherub/backups/100502.sql
/usr/libexec/ld-elf.so.1: Shared object "libmysqlclient.so.10" not found

[George L]

did you recently upgrade php or mysql ?

[grrlburn]

This is the thread where all my server config is listed.

http://www.vbulletin.com/forum/showt...threadid=55291

[George L]

can you submit a support ticket at http://vbulletin.com/members/support.php with your ssh/telnet login details, root and mysql root passwords as well so i can check this out..

[grrlburn]

I submitted a support request.

Chris