Backup problem

[treader]

This morning we upgraded to 3.6.8. I decided to do a backup of the database, and got this error:

Invalid SQL:
SELECT * FROM vb_attachment;

MySQL Error : MySQL client ran out of memory
Error Number : 2008


My partner then tried to do a backup from his location, and it worked just fine. Any ideas why it wouldn't work for me? I did note that the above error message said at the top "Database error in vBulletin 3.6.7", even though the version number in the cp said 3.6.8...could this error be due to the fact that I hadn't logged out and back in since the upgrade?

[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