EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)
-   -   Windows: Sourcing SQL Files (https://www.eqemulator.org/forums/showthread.php?t=37347)

Stabones 10-02-2013 08:12 PM

Windows: Sourcing SQL Files
 
So, there are a lot of files to source...

source a.sql
source b.sql

...


source zz.sql

No thanks.

For future sourcing, use:

Code:

copy /b *.sql all_files.sql
This will take all .sql files in the directory and concatenate them into one. Want to pick and choose what to source? Select all .sql files you are interested in, copy them to a temp folder, and then run the copy command above!

Stabones

sorvani 10-02-2013 08:25 PM

There are like two things to source.

Stabones 10-02-2013 08:31 PM

Not when you do proper source control

lerxst2112 10-02-2013 08:42 PM

for %i in (*.sql) do mysql -uroot -ppassword peq < %i

Stabones 10-02-2013 10:18 PM

Quote:

Originally Posted by lerxst2112 (Post 224587)
for %i in (*.sql) do mysql -uroot -ppassword peq < %i

Always good to see other solutions.

Cheers!


All times are GMT -4. The time now is 09:18 PM.

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.