Restore database???

[ConMeoCon]

Hi there,
I have backup the database from the forum version 2.2.6. The name of the database is vbulletin.sql. Right now if I am install a brand new forum version 2.2.6 in a different server, how can I restore those database into the new forum that I install in the new server?
Thanks

[Jake Bunce]

Here is a guide for moving servers. It lists the mysql commands for backing up and restoring your database.

http://www.vbulletin.com/manual/movingservers.html

[ConMeoCon]

Originally posted by Jakeman
Here is a guide for moving servers. It lists the mysql commands for backing up and restoring your database.

http://www.vbulletin.com/manual/movingservers.html

Is there another way that I can do it with out using the ssh program? I am really bad in it .

[Steve Machol]

There is no other reliable method for restoring a backup.

[ConMeoCon]

Originally posted by Steve Machol
There is no other reliable method for restoring a backup.

on the manual, do I have to type and do the exactly thing? or I have to plugin info in some part?
like
<LI>Telnet/SSH into machine1, and from the command prompt type the following:
cd /path/to/yourbackupdirectory <LI>Then type
ftp MACHINE2
Replace MACHINE2 with the host name (eg. www.example.com ) or IP address (eg. 192.168.0.0 ) of your new server. This should open a connection and ask for your username/password, then it should say ftp> <LI>Type the following, hitting enter after each line:
bin
cd /path/to/newdirectory
put dump.sql
I dont know where is my yourbackupdirectory and the newdirectory is...

[Steve Machol]

You'll need to change the variables to match your system.