How to run multiple .SQL queries at once?

[Deathbringer123]

Hey

Just redownloaded TrinityCore got the server files sorted e.g .dll's and manin server and auth sorted but now im doing the database done auth and character db and run the TDB sql file for the world and now need to run the 1000's SQL Updates in the world update folder and im not up for sitting there and doing it all manually and would like to know if it is possible to run them all at once with HeidiSQL or any other program, any help is greatly apreciated

Thanks

[stoneharry]

Are you SURE you need to apply those updates?

I think you only need to apply the ones newer than your database version (which is only a couple if any). If you really need to apply them all, write a script to merge the files and then execute it. But I don't think you do, not at all. :G

[Deathbringer123]

ok , will check them now to see which ones need doin

Thanks

[Deathbringer123]

Yeah need to run them all The database is version is 02/12 and i got updates higher then that

[Deathbringer123]

Its alrite i got a .bat to combine the updates then i just run 1 sql file


Thanks anyway

[LilleCarl]

open a commandline and type:
Windows:

copy *.sql combined.sql

*NIX:

cat *.sql > combined.sql