Database Restoring

[Khalid-B]

Hello.

I have a 4.5GB database in my computer and now i want to restore it at server but cant upload always timed out.
How can i upload it ?
can some one please help me ?

Thaks

[Marco van Herwaarden]

First of all, how are you uploading the backup file?

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

[snakes1100]

The most likely cause of the failure of uploading a 4.5gb file thru ftp is that the kernel dont support large files.

You will need to split the file up first then upload it in smaller chunks, if you have a linux box at home this would be easy, on a winblowz desktop, you will need to get something link winzip, but if your server is linux, it needs to support unzipping of files as well.

http://www.winzip.com/powertips.htm#split