Mysql run multiple sql files

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?

asked Mar 16, 2010 at 22:17

Assuming you're using bash:

cat *.sql | mysql

answered Mar 16, 2010 at 22:31

Etienne DechampsEtienne Dechamps

23.1k4 gold badges31 silver badges29 bronze badges

4

for %S in [*.sql] do mysql -u user_name database_name < %S

or

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

sth

214k50 gold badges273 silver badges363 bronze badges

answered Aug 14, 2010 at 3:58

AnuchitAnuchit

1211 silver badge2 bronze badges

1

For Windows:

FOR %%A IN ["*.sql"] DO "D:\mysql\Install\MySQL Server 5.5\bin\mysql" --user=scooby --password=pwd123 databasename < %%A >output.tab

answered Jul 16, 2015 at 18:05

mpschmittmpschmitt

1111 silver badge2 bronze badges

0

bash:

mysql <