How to Import SQL file into mysql

Question

I have a database called edureka. 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 edureka.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:/edureka.sql;

But this didn't work.

Comments

I did this, but for some reason not all of my tables were imported..what do I do?

---

Hello,

If you are using phpMyAdmin, you can simply create a database and then go to the import tab and upload there, or you can SSH to your server and run 'mysql -u username -ppassword database_name < FILE.sql'. Make sure -ppassword has your password after it with no spaces.

Answer 1

Hello @kartik,

From the mysql console:

mysql> use DATABASE_NAME;

mysql> source path/to/edureka.sql;

make sure there is no slash before path if you are referring to a relative path.

Hope it helps!!
Thank You!