Import SQL file into mysql

Question

I have a database called nitm. I haven't created any tables there. But I have a SQL file that contains all the necessary data for the database. The file is nitm.sql which is in C:\ drive. This file has a size of about 103 MB. I am using wamp server.

I have used the following syntax in MySQL console to import the file:

mysql>c:/nitm.sql;

But this didn't work.

Answer 1

Run these commands in the MySQL console to import the SQL file :

mysql> use DatabaseName;

mysql> source_path/to/file.sql;

Note: Don't use a slash in the starting of the file path referring to the relative path. 

I recommend checking out this SQL Tutorial to learn the fundamentals of SQL.