how to import multiple sql file in to same mysql database automatically using shell script

Question

Sql file to mysql database using shell script. I have ten more .sql files. But all of the .sql files are imported into same database. The .sql files are in .gz format.

use google. it's not the place where you will find application. — Ripa Saha
– Ripa Saha, Commented Mar 19, 2014 at 9:49

poncha · Accepted Answer · 2014-03-19 09:52:58Z

2

bash:

for sql_file in *.sql; do mysql db_name < $sql_file; done

(Assuming you wish to import all the sql files in the current directory)

answered Mar 19, 2014 at 9:52

poncha

7,8763 gold badges36 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

how to import multiple sql file in to same mysql database automatically using shell script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related