Import SQL file into mysql

From the mysql console:

mysql> use DATABASE_NAME;

mysql> source path/to/file.sql;

make sure there is no slash before path if you are referring to a relative path... it took me a while to realize that! lol

Finally, i solved the problem. I placed the `nitm.sql` file in `bin` file of the `mysql` folder and used the following syntax.

C:\wamp\bin\mysql\mysql5.0.51b\bin>mysql -u root nitm < nitm.sql

And this worked.

If you are using wamp you can try this. Just type use your_Database_name first.

1. Click your wamp server icon then look for MYSQL > MSQL Console then run it.

2. If you dont have password, just hit enter and type :

   mysql> use database_name;mysql> source location_of_your_file;

   If you have password, you will promt to enter a password. Enter you password first then type:

   mysql> use database_name;mysql> source location_of_your_file;

location_of_your_file should look like C:\mydb.sql

so the commend is mysql>source C:\mydb.sql;

This kind of importing sql dump is very helpful for BIG SQL FILE.

I copied my file mydb.sq to directory C: .It should be capital C: in order to run

and that's it.