Restore

[GhOsTxX]

Hello guys, how do i restore a DB in vBulletin ACP? i have a DB from a while back that i need to restore, so can som1 tell me how to restore it? thank you.

[Howell]

I use this handy script. :)

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

[GhOsTxX]

yes, but is there a feature on vB to just restore the DB?

[Howell]

No unfortunately there isn't that function.

[BlueEew]

I used bigdump to restore when I was from a free phpBB forum to a paid phpBB forum. I have never done nothing like that before however it went well.

I used Impex when I moved from phpBB to vBulletin.

[Opserty]

Restoring The Database via SSH/Telnet (http://www.vbulletin.com/docs/html/main/maintenance_ssh_restore)

Restoring The Database via phpMyAdmin (http://www.vbulletin.com/docs/html/main/maintenance_phpmyadmin_restore)

Restoring your MySQL Database Manually (http://www.vbulletin.com/docs/html/main/manual_database_restore)

[GhOsTxX]

thanks for the help gois. pce

[Dismounted]

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