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 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.

Accepted Answer

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.

Import SQL file into mysql

Solution

Problem

Related problems