PDA

View Full Version : Transferring hosts trouble


WishLine
08 Jul 2008, 12:10
Hello all,

I'm WishLine and I help run a vBulletin site. I have problem becayse I need to transfer hosts and I need to ask a question due to a problem I can't get round :confused:

Me and my collegue have successfully transferred all the files from one site to another, but we're aving lots of trouble with the database. We've managed a full database dump from the old site and it's host but when we try and use PhpMyAdmin to upload the database .sql file (About 11 MB) it times out after 300 seconds (five minutes). HOw can I eithr

Force MyAdmin to complete the whole upload
Break the upload into sections so that it will work below the time limit
Use another program entirely to do it for me


Thanks, we're really stuck!
WishLine

Dismounted
08 Jul 2008, 12:18
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

WishLine
08 Jul 2008, 12:25
Thanks there. I'm using bigdump ;)

Regards,
WishLine

Kinneas
14 Jul 2008, 14:44
I've used bigdump quite a few times, very handy tool.