SQL restore question
 

A while ago I made a machine switch. Using Navicat I exported my database to a .sql file. I just finished getting everything reworking, and built. I was wondering how you restore your db from a sql file? I just hope I didn't do it wrong :shock:

Found the answer
 

Found the answer to my own question:

mysql -h localhost -u [MySQL user, e.g. root] -p[database password] [name of the database] < [name of your sql dump, e.g. sqldump.sql]

worked like a charm, just in case anyone else ever wonders :-).

Now I can get to work!

Or, in Navicat, you can create the database you want to use and right click that database and select "Run Batch File". That will do the same thing.