An export made with a webbased script (like phpMyAdmin or AdminCP) can often cause problems because of timeouts.
The only reliable way to backup is using shell commands. See the following pages in our manual:
Backup:
http://www.vbulletin.com/docs/html/m...nce_ssh_backup
Restore:
http://www.vbulletin.com/docs/html/m...ce_ssh_restore
Some people have also reported success with these scripts:
MySQLDumper:
http://www.mysqldumper.de/en/index.php
MySQLHotxcopy:
http://www.vbulletin.com/forum/showt...t=mysqlhotcopy
Bigdump:
http://www.ozerov.de/bigdump.php