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 http://stackoverflow.com/questions/17666249/how-to-import-an-sql-file-using-the-command-line-in-mysql — Kashif Ullah, Mar 29 '16 at 19:52

Barmar · Accepted Answer · 2016-03-29T20:50:27.550

3

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 '16 at 20:50

answered Mar 29 '16 at 19:51

Barmar

669,327
51
454
560

1

I found away, I logged into mysql, use database name, and ran the following source name.sql and this populates my table I created – Patrickmysql Mar 29 '16 at 20:45
I thought you said you wanted to do it from the Linux command line. – Barmar Mar 29 '16 at 20:47
Sorry that was an error on myside. I ment from the mysql line – Patrickmysql Mar 29 '16 at 20:49

Importing sql file to MySQL

1 Answers1