Import SQL file into mysql

I have a database called nitm. I haven’t created any tables there. But I have a SQL file which contains all the necessary data for the database. The file is nitm.sql which is in C:\ drive. This file has 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.

18 Answers
18

Leave a Comment