Restore from Backup on Filesystem [Archive]

roymogg

10-05-2008, 10:38 AM

Hi,

I normally back up the forums using php to a local zipped file but on the main forum the size of file is starting to grow - I noticed that under maintenance it is possible to store a backup on the file system.

Is is possible to restore from this back up within admincp - I cannot clearly see how to do this.

RoyMogg

Dismounted

10-05-2008, 11:24 AM

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

Bigdump:
http://www.ozerov.de/bigdump.php