Restoring

[Mag1c]

Ok well I backed up my db to a .sql file which is 10 mb. I reinstalled vB and i need to restore my forum so i can get all my users usergroups and posts back. I need to know how other than phpmyadmin.

Thanks,
Mag1c

[Lynne]

The best way is to use shell access - ssh.

mysql -uDBUSERNAME –p DATABASENAME < /PATH/TO/DUMP.SQL

DBUSERNAME - your mysql username
DATABASENAME - your mysql database name you want to restore to

you will be prompted for you mysql password

[Mag1c]

And how do you use ssh??

--------------- Added 1203628210 at 1203628210 ---------------

or is there another way

[snakes1100]

Depending on your host and your type of hosting account, you probably dont have ssh access anyways, you can use bigdump, its a php script based importer.

Is this a godaddy account and you cant get their crap server with phpmyadmin to import the db?

[Mag1c]

1and1

[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