terminal command for mysql file import

Question

I am trying to import a 60 MB file, filename-20120201.tbz, into a newly created MySQL database. I am using terminal, and have opened the database by the prompt use new_database.

How do I import this file correctly? I am on a Mac. Thanks.

user229044 · Accepted Answer · 2012-02-02 16:51:18Z

27

If you are running mysql and using your newly created database use the below code to run the script file

mysql> SOURCE input_file

or from terminal

mysql -u root -p database < filename-20120201.tbz

edited Feb 2, 2012 at 16:51

user229044♦

241k41 gold badges347 silver badges350 bronze badges

answered Feb 2, 2012 at 6:29

Naveen Kumar

4,6011 gold badge20 silver badges39 bronze badges

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

Comments

Community · Accepted Answer · 2012-11-14 15:25:00Z

11

Try

$ mysql -u root -p new_database < db-dump.sql

Where: new_database is the name of your new database and db-dump.sql is the mysql file to be imported

edited Nov 14, 2012 at 15:25

CommunityBot

11 silver badge

answered Feb 2, 2012 at 4:05

Rezigned

4,9501 gold badge22 silver badges19 bronze badges

Comments

Tadeck · Accepted Answer · 2012-02-02 04:09:29Z

3

This should do the trick:

\. filename

(provided within MySQL's command line, assuming filename is SQL file)

answered Feb 2, 2012 at 4:09

Tadeck

138k28 gold badges155 silver badges201 bronze badges

1 Comment

Axel A. García Over a year ago

Thanks! This is excelent for SQL data dumps with automatic database creation like CREATE DATABASE IF NOT EXISTS

Fahim Parkar · Accepted Answer · 2012-02-02 04:11:33Z

0

Place the password immediately after -p

mysql -u root -ppassword database < file.sql

answered Feb 2, 2012 at 4:11

Fahim Parkar

31.8k46 gold badges168 silver badges285 bronze badges

3 Comments

Axel A. García Over a year ago

Is this safe? What if somebody reads your terminal history? Or simply reads while you're typing.

Fahim Parkar Over a year ago

@AxelA.Grazx : nice comment... does that mean you will keep people around while typing password or command? does anyone see when you type your twitter password?

Axel A. García Over a year ago

I'm just saying that mysql -u root -p database < file.sql will ask your password in a safer way. And if somebody see you typing your Twitter password they would see ***********. Just a little peek on -pMyMySQLPassword would be needed to know your password. And excuse me if this comments sounds rude ;)

Collectives™ on Stack Overflow

terminal command for mysql file import

4 Answers 4

Comments

Comments

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related