PDA

View Full Version : How do I backup mysql through telnet when doing "LOCK TABLES"?


Gutspiller
08-12-2005, 02:37 PM
I followed the instructions here: http://www.vbulletin.com/docs/html/main/maintenance_ssh_backup but I got this error:


-- Server version 4.0.22-standard-log
mysqldump: Got error: 1103: Incorrect table name '/path/forumdump-aug-8.sql' when doing LOCK TABLES
root@satan [~]#

I remember reading about table locking and how it prevents coruption, but I thought it would only be on if my forum was still active? I turned off my forum above and ran the above linked instructions and got that quoted error. Do I need to include some type of switch or something to get it to do the backup?

If somebody can help me I would appreciate it. Thanks.

Marco van Herwaarden
08-12-2005, 03:53 PM
I think you made an error on the command line. Please post the full comman you are trying.