Re: Running multiple sql files

[Peter Brawley]

The short answer is recursion: write a script that invokes other scripts.

Have a look at the manual pages for the mysql client program. Its command to run sql script c:/sqldir/scrip1.sql is ..

source c:/sqldir/scrip1.sql

Note, no terminating semicolon. You can write a script that does something like the following sequence for each of 260 scripts ...

source c:/sqldir/scrip1.sql
show create table table1;

... and if the mysql client program iks called with the --tee option you will have a text file of results so you can fix errors that occurred.

You can run a similar script in WorkBench, see its manual pages for how.