how to restore the vBulletin database?

[tipu sulthan]

how to restore the vBulletin database? Confused

i was used another server before

now changed to Web Hosting .i want restore my old vBulletin database backup

the backup vBulletin database is 13.5 mb it only take 5.00mb what i do to restore
plz help me


this link dont help me http://www.vbulletin.com/docs/html/manual_database_restore

[Lynne]

What about that link doesn't help you? Those are the two recommended ways to restore the database.

[Marco van Herwaarden]

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

[stinger2]

MySQLDumper and big dump work great.....i second that