Run MySQL query on command line from a script [duplicate]

Question

How can i run a mysql query from a script via the ubuntu command line using the mysql client? I know i can use the following command:

mysql -uroot -psecret -e "select * ..."

But my query is too big and would like to be read from a script instead. I tried the following and did not work:

mysql -uroot -psecret < /path/to/script.sql

i get the error:

ERROR 1046 (3D000) at line 1: No database selected

You need to specify the database name: mysql -uroot -psecret yourDatabaseName < /path/to/script.sql — Tim Biegeleisen
– Tim Biegeleisen, Commented Sep 7, 2016 at 10:05
The other way is to add use xxxx; inside of your script.sql — Ben Lin
– Ben Lin, Commented May 22, 2017 at 4:47

Trueliarx · Accepted Answer · 2016-09-07 10:10:31Z

1

Just specify the database name

mysql -D yourdbname -uroot -pYourpassword < /path/to/script.sql

-D, --database=name Database to use.

-p, --password[=name] Password to use when connecting to server. -h, --host=name Connect to host.

answered Sep 7, 2016 at 10:10

Trueliarx

887 bronze badges

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

Comments

kernal_lora · Accepted Answer · 2016-09-07 10:05:32Z

0

I think this way you should try.

mysql --host=localhost --user=your_username --password=your_password  -e "script.sql"

answered Sep 7, 2016 at 10:05

kernal_lora

1,1553 gold badges13 silver badges26 bronze badges

I think Tim Biegeleisen solution also works