How to install a .sql file using MySQL Command line Client

Question

I need to install or import a .sql file into an empty database that I've created. The .sql file will install all the tables etc.

When I click MySQL Command line Client prompt, I add my credentials and then...(to install / import the .sql file)?

Thanks guys!!

Ok, I've managed to install / import the .sql file. One thing I'd like to add to the answers below is when you type in the file name, eg: script.sql - make sure you include the path so that the command knows where to find the file, so you would put \. C:\yourdomains\thedomain\wwwroot\script.sql — Reflex84
– Reflex84, Commented Jan 16, 2012 at 17:29
Since you managed to solve your problem, please accept one of the answered that helped you - this will let people reading this page in the future know what helped. :) — Brighid McDonnell
– Brighid McDonnell, Commented Aug 2, 2012 at 17:24

Devart · Accepted Answer · 2012-01-16 17:11:45Z

29

Something like this:

shell> mysql db_name < script.sql

...specify your options: --user, --password, --host, --port...

More information - mysql — The MySQL Command-Line Tool.

answered Jan 16, 2012 at 17:11

Devart

120k23 gold badges172 silver badges189 bronze badges

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

Comments

paulsm4 · Accepted Answer · 2012-01-16 16:59:17Z

21

From the MySql prompt, type:

\. file_name.sql

answered Jan 16, 2012 at 16:59

paulsm4

123k23 gold badges175 silver badges245 bronze badges

1 Comment

Tyler Rick Over a year ago

This is good to know, but it's slower than the mysql < file_name.sql when it contains 1000s of queries/inserts. For each insert, it will output: Query OK, 1 row affected (0.03 sec) Query OK, 1 row affected (0.02 sec) Query OK, 1 row affected (0.03 sec) , which can really slow things down.

Yash · Accepted Answer · 2012-08-02 10:16:41Z

7

What worked for me was- on command prompt:

mysql -u root -p < filename.sql

I read somewhere that to make things easier I should keep the file in the same root directory as my command prompt was in. After running the above command, it asked me for the password. Typed the password, hit enter and I was back on my command prompt. Got pissed, opened mysql prompt, checked, the imported DB was present. Happy!

answered Aug 2, 2012 at 10:16

Yash

711 silver badge1 bronze badge

2 Comments

Nitin Bansal Over a year ago

u might want to include database name also: "mysql -u root -DBASE <database_name> -p < filename.sql"

Momro Over a year ago

I found that you don't need the -DBASE parameter and may simply write "mysql -u root <dbname> -p < filename.sql"

nhahtdh · Accepted Answer · 2013-09-05 18:06:17Z

2

This is another way to do it in Linux

mysql databaseName -uUSERNAME -pPASSWORD -e "source LOCATION_OF_FILE"

Example:

mysql studentDB -ustudent1 -pstuden1Pass -e "source /tmp/studentInserts.sql"

edited Sep 5, 2013 at 18:06

nhahtdh

56.9k15 gold badges131 silver badges164 bronze badges

answered Sep 5, 2013 at 18:02

Maximus

5691 gold badge6 silver badges20 bronze badges

Comments

Ashith · Accepted Answer · 2013-01-30 13:43:04Z

1

just thought of perfecting the great answers from wise users. before importing a .sql database

Create a new database or use existing database.
if your .sql file is saved in F as script.sql provide command as . F:\script.sql enjoy...

answered Jan 30, 2013 at 13:43

Ashith

436 bronze badges

Collectives™ on Stack Overflow

How to install a .sql file using MySQL Command line Client

5 Answers 5

Comments

1 Comment

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related