Log in

View Full Version : Uploading a forum sql


silvermerc
02-27-2009, 05:51 AM
How would i upload a forum sql, Once of my moderators got hacked and i have a backup of yesterday, Just wondering where would i upload it ect.
Ross

Dismounted
02-27-2009, 10:45 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&highlight=mysqlhotcopy

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

silvermerc
02-27-2009, 10:59 AM
Well i have the files in like cut up pieces heres a screenshot.
http://www.tehupload.com/uploads/54093c9ce395f3avbulletin.png

Marco van Herwaarden
02-27-2009, 11:34 AM
Can you post the contents of 1 of these files (a smaller one).

silvermerc
02-27-2009, 11:37 AM
http://www.tehupload.com/uploads/9249410b41bfa0emarco.png

Marco van Herwaarden
02-27-2009, 12:12 PM
You should be able to load those files with any of hte methods mentioned by Dismounted.

You will need to process ALL these files or merge them together into 1 big file.

silvermerc
02-27-2009, 12:32 PM
Yeh i got it working, Thanks for your help guyzzz