1 | On the new server, if necessary, create the database which your vBulletin will be installed in. Refer to your host for specific information on how this is done. |
2 | Telnet/SSH into machine2. |
3 | Type:mysql -uUSERNAME -p NEWDBNAME < /PATH/TO/NEW/DUMP.SQLYou should change the following parts of this line:
|
Note:
We recommend you use the method described above to restore your database, as it is the most reliable. If you don't have access to SSH then there are alternate instructions on restoring your database available in the technical section of the manual.
-D newdatabasename
rather than
-P newdatabasename
the -p command is needed, as it is to prompt a password.
Also, when entering the location of a file, the first / may not belong. That is to say, if the error that a file can not be found is given, try:
< path/to/dump.sql
instead of
< /path/to/dump.sql
Change directory to where the dump.sql file is located
If your current directory is not the same as the location of the dump.sql file, use a cd command to change location.
Connect to the MySQL server using the mysql program
At your command-line prompt, issue this command:
shell> mysql -u root -p
Create the vB database and select it as the default database:
In the mysql program, issue the following statements:
mysql> CREATE DATABASE vb_database;
mysql> USE vb_database;
Load the contents of dump.sql into the vb_database
Issue a SOURCE command to tell mysql to read and process the contents of dump.sql:
mysql> SOURCE dump.sql;
You'll see quite a bit of output as mysql reads queries from the dump.sql file and executes them.