Database Back Up Problems/Error on page

[Borden]

When I do a database back up to the server through my admin cp it does not say completed or done at the end. Is the back up complete and it is not saying done at the end because the forum is so large?

When I look at my front page of my forum in IE it says I have an error in the lower left hand corner of the browser.

Line 2746

Char 12

Error Expected','

How can I fix this error? I am running VB 3.6.5

[Marco van Herwaarden]

The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/maintenance_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/maintenance_ssh_restore

P.S. If you don't have shell access, some people have also reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showthread.php?t=134821&highlight=mysqlhotcopy

Bigdump:
http://www.ozerov.de/bigdump.php