Importing .sql files back up

[PhanTuhC]

Hey I was wondering how I put my vbulletin.sql back onto my forums, I changed my host and it deleted my forums, does anyone know how I could put my .sql back onto my forums?

[Andreas]

Do you have shell/ssh access?

If so
1) Upload the file somewhere on the server, for security reasons outside the webserver root
2) Login
3) mysql - u <mysqlusername> -p. You will be asked for your password afterwards
4) use <database for vB>
5) source <path/to/sql-file>
And wait ...

Note that <foobar> must be replaced with the actual value, without the <>

[allan grossman]

If you want to do it all on one line -

mysql -uusername -ppassword databasename < /path/to/vbulletin.sql

[PhanTuhC]

Hey guys, thanks for your help but I can't seem to get it, where do I enter the mysql infomation at??