How to run multiple file .sql with mysql?

Question

I tried to run this command in shell:

mysql> source /path/*.sql

But I did not have any results. Do you have any suggestions what is wrong?

Rahul Tripathi · Accepted Answer · 2016-01-29 09:45:13Z

3

You can try to use Bash like this:

cat *.sql | mysql

or

cat script*.sql | mysql -u root -pmypassword  yourdatabase

answered Jan 29, 2016 at 9:45

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

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

3 Comments

Just an addendum, this works as long as the statements are terminated by ;

i tried but the result on shell is this: mysql> cat *.sql | mysql -> and than i cannot do anything on file in my folder /path/to/folder/files.sql

the second one is correct in my case :) thank you so much