Database Backup Error

[Racecar]

I get the following error when trying to backup the database

Warning: mysql_query() [function.mysql-query]: Unable to save result set in [path]/includes/class_core.php on line 408

Not sure what I need to do to fix. I have re-installed vbulletin but get the same error each time.

[Lynne]

You should not backup your database from the admin cp. This is from the manual:
Backing Up The Database via SSH/Telnet (http://www.vbulletin.com/forum/../docs/html/maintenance_ssh_backup) or
Backing Up The Database via phpMyAdmin (http://www.vbulletin.com/forum/../docs/html/maintenance_phpmyadmin_backup)

Restoring The Database via SSH/Telnet (http://www.vbulletin.com/forum/../docs/html/maintenance_ssh_restore) or
Restoring The Database via phpMyAdmin (http://www.vbulletin.com/forum/../docs/html/maintenance_phpmyadmin_restore)

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)

[Powlo]

The software i use is mysql Administrator, it makes life so easy to backup & restore you can also set up backup schedules. I backup twice a day since ive being hacked.

Oh and guess what... its FREE!!

http://dev.mysql.com/downloads/gui-tools/5.0.html

[snakes1100]

It appears that sql is running out of memory when trying to do the dump, have your host check, what are you using when trying to do the sql dump?