[GUIDE][Pictures]Combining a bunch of SQL files into one

[Kiyoshi]

Ok First off I would like to say that I know latruwski is the original creator of this guide. All I did was change a some words and add some pictures.


Ok this guide was made for the people who wanted to execute a lot (or a few) SQL files at once. What it will do is take all the SQL files in a folder and combine it into one file in the same folder.

In this example I will be using the LUA++ "SQL Additions" folder.

Let's begin by clicking "start" then "run" and then type in "cmd" to bring up the command prompt:



After that type "cd" and then the directory your file are in (the URL of the folder)

for my example it would look like this:

cd C:Documents and SettingsDavidDesktopLUA++SQL additions

then press enter and it should look something like this (depending on what folder you're using):



After you're done with that type "copy *.sql all.sql" into your command prompt (make sure to change "all" to what you want the file name to be). Mine will look like this:

copy *.sql LUA.sql

Change "all" to what you want the file name to be and press enter and the new SQL file should be in the same folder as the rest of the SQL files:



Now as I said earlier I am not the finder of this little trick, latruwski is. The original post can be found here:

http://www.mmowned.com/forums/emulator-server-guides/88662-guide-putting-lot-sql-files-into-1-big-sql-file-fast.html

This post cannot be bumped because it is more than 99 days old and that is why I remade the guide.

Thank you,

~[Cloud]~

[latruwski]

nice to see someone still finds it usefull after that long time Nice to see one of my threads got refreshed

grtz