How to import sql file into a bash script

Question

On Debian, I want to import a huge sql file with a command in a bash script. Currently, I use this command:

mysql -u root -p myDatabase < my_backup.sql

But that's not fine in a bash script because it asks for the root password ! I tried to provide it in the command with the -p argument, but it doesn't seems to work... Do someone have a solution ?

Thanks

Mark Setchell · Accepted Answer · 2013-11-18 15:08:16Z

13

There is no space between the "-p" and your password.

Per mysql documentation:

These work:

-uuser_name -ppassword 
-u user_name -ppassword

This does not:

-u user_name -p password

http://forums.mysql.com/read.php?10,229253

answered Nov 18, 2013 at 15:08

Mark Setchell

210k32 gold badges309 silver badges503 bronze badges

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

2 Comments

maxime Over a year ago

I tried mysql -u root -p="mypassword" myDatabase < my_backup.sql, but it denies the access... :(

Mark Setchell Over a year ago

You need to drop the equals sign and double-quotes.

Collectives™ on Stack Overflow

How to import sql file into a bash script

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related