Run multiple sql files in mysql batch

Question

to run a single file you can run in mysql

.\ filename

or you outside of mysql you can run

mysql < filename

I have a directory of sql files so I'm trying to run them all at once by using a wildcard

*.sql

but it doesn't work.

Any ideas?

Answer 1

Assuming you're using bash:

cat *.sql | mysql

Answer 2

for %S in (*.sql) do mysql -u user_name database_name < %S 

or

mysql -u user_name -p password database_name < file.sql