Importing sql file to MySQL

Question

I have a sql file containing data that I want to import to a table on MySQL.

I know the dead easy way is to use a a management software like MySQL work bench and import it that way but I want to learn how to it by command line

I already have sftp the file to the root directly on my linux system but im unsure how to import the data from the .sql file to the table I have in my database.

possible duplicate stackoverflow.com/questions/17666249/…

Kashif Ullah
– Kashif Ullah

2016-03-29 19:52:30 +00:00
Commented Mar 29, 2016 at 19:52 — Kashif Ullah
– Kashif Ullah, Commented Mar 29, 2016 at 19:52
What else did you try so far, did you search on google?

Kashif Ullah
– Kashif Ullah

2016-03-29 19:53:08 +00:00
Commented Mar 29, 2016 at 19:53 — Kashif Ullah
– Kashif Ullah, Commented Mar 29, 2016 at 19:53

Barmar · Accepted Answer · 2016-03-29 20:50:27Z

5

Use the file as input to the mysql command from the shell command prompt.

$ mysql -h servername -u username -p databasename < filename.sql

You will then be prompted for your password.

If you're already inside the mysql program, you can use its source command.

mysql> source filename.sql

edited Mar 29, 2016 at 20:50

answered Mar 29, 2016 at 19:51

Barmar

789k57 gold badges554 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Patrickmysql Over a year ago

I found away, I logged into mysql, use database name, and ran the following source name.sql and this populates my table I created

Barmar Over a year ago

I thought you said you wanted to do it from the Linux command line.

Patrickmysql Over a year ago

Sorry that was an error on myside. I ment from the mysql line

Collectives™ on Stack Overflow

Importing sql file to MySQL

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related