Database Backup

[Slayne]

I was trying to backup via server as per the recommendation and it seems to go through about half way before I get the following error.

Database error in vBulletin 3.7.0:

Database error in vBulletin 3.7.0:

Invalid SQL:
SHOW CREATE TABLE vb_postedithistory;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Saturday, July 12th 2008 @ 12:30:45 PM
Error Date : Saturday, July 12th 2008 @ 12:31:08 PM
Script : http://forums.digitalsloth.net/admin...php?do=sqlfile
Referrer : http://forums.digitalsloth.net/admin....php?do=choose
IP Address : 72.130.111.89
Username : Slayne
Classname : vB_Database
MySQL Version :


Any suggestions on how to remedy this? As is, I think I'm only getting about half way through before it stops. I get this even after running the optimize / repair utility.

[rgMM]

MySQL server has gone away is a server issue, most likely you need to increase some timeout or other mysql values

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

[Slayne]

Any ideas on what I'd need to tell my host in resolving the problem?

[rgMM]

First thing to ask is for them to tell you what is the 'wait_timeout' in my.cnf file (for mysqld) and perhaps starting to increase it in 60 second increments and restart mysqld, then see if the errors continue.

[Slayne]

On a shared and it will affect everyone, so looks like I'll just have to use the php method.

[Slayne]

It now gives me the same error when doing the PHP method. Assuming the host hasn't changed anything, would anything else cause this error that I can fix?

[Steve Machol]

This is a server issue. You will have to contact your host.

Note: The only consistently 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 timeout 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

If you don't have telnet or SSH access, some people have 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

[Slayne]

If I use mysql admin and just download a backup of the mysql database that the forum is using, would this be basically the same thing?

[Steve Machol]

No, it wouldn't. It will have the same timeout risk.