shell - How to run multiple file .sql with mysql? -


i tried run command in shell:

mysql> source /path/*.sql 

but did not have results. have suggestions wrong?

you can try use bash this:

cat *.sql | mysql 

or

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

Comments