PDA

View Full Version : How to fix this database error during backup


Nick1337
03-21-2008, 05:11 PM
When i try to backup the sql database in vbulletin acp i get this error about half way through:

Database error in vBulletin 3.7.0 Release Candidate 1:

Invalid SQL:
SELECT * FROM post;

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Saturday, March 22nd 2008 @ 12:09:26 AM
Script : http://sitename.com/admincp/backup.php?do=sqlfile
Referrer : http://sitename.com/admincp/backup.php?do=choose
IP Address : 71.**4.1*5.**
Username : Nick1337
Classname : vB_Database
MySQL Version :

Marco van Herwaarden
03-21-2008, 05:22 PM
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