Alex Rivera | Logout

Import SQL file into mysql

Asked 2011-03-01T09:56:54.600
205

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.

mysql sql database windows import
Edit
Report

1 Answer

1
mysql>c:/nitm.sql;

That would write the output of the mysql command to 'nitm.sql;' (What's the ';' supposed to do?) Assuming you've got a copy of the original file (before you overwrote it) then:

mysql < c:/nitm.sql
answered 2011-03-01T10:13:19.450

Your Answer