I've got an old .SQL file of my database and....

[split-vizionz]

I got the .sql file that I recieved when I was backing up my forum awhile ago... My site shut down for awhile and now Im having a brainfart. I want to ressurect it on vbulletin 3.0 but where do I upload the sql file to so that it will bring back my old database? like where within the server? keep in mind that this file is from an older version of vbulletin, will it still work.

[djnoz]

Here's what to do..

Upload the old sql file to a directory on your server (preferably outside the web directories - for security reasons)

Create a new, blank database or clear out an existing one.

Go into SSH and type the following command

mysql -u [mysql username] -p [.sql filename] > [name of database you created/cleared]

This restores the contents of the SQL file into the database.

Now download vb3, edit the file at includes/config.php, upload everything into your web directory and run the upgrade script, this will convert your forums to vb3.

[split-vizionz]

your the man! thanks for the help!

[split-vizionz]

is that the same way you do it onm a windows server? or is that strictly for linux

[filburt1]

It is effectively the same on Windows, although be sure to note that mysql.exe is in MySQL's bin directory and not in the path by default.