[Guide]Putting a lot of SQL files into 1 big SQL file FAST !

[latruwski]

Ok it is verry simple... first not i have to make:
this will not work with external hard disks !!! it has to be an internal one!

Ok so for example you download the latest NCDB revision from the SVN and you open the folder and what do you see?
OMFG i have 77 sql files O.o Do i need to execute all of them?
No! You can make 1 big SQL file from those 77 seperated files!
Here is how we do it:

Put your NCDB revision in a random place... for me it was
C:\\merge\

screenshot of the folder:

link to the screen: http://www.imagebong.com/photos/Screen02_7.JPG

Now go to Start -> Run
type "cmd" and press enter

now in the command prompt type:

cd c:\\merge

change c:\\merge to whatever folder you used !

now type:

copy *.sql all.sql

change all.sql to whatever name you would like the file to have!

a screenshot of all of this:



after that you should find a file called "all.sql" in the same folder you are done !


grtz

[Viter]

good guide +rep x4

[Althor]

wow, ive been wondering how to do this to make backing up all my updates easier +rep

[latruwski]

wow, ive been wondering how to do this to make backing up all my updates easier +rep

thx for the comments guys

[massanaconda]

LOL thx +rep

[condoom]

i dont get it :P

[condoom]

Wtf is NCBD and SVN or something?

[latruwski]

Wtf is NCBD and SVN or something?

NCDB is a database and the place to get it is from svn:
http://projects.emupedia.com/svn/ncdb/
login: anonymous
no password

when you download one of the revisions you will see you will have a SQL file for each table... and executing them all one by one is lot of work that is why i posted a guide on how to make 1sql file out of 100 for example

grtz

[condoom]

do i need to download them all?

[condoom]

i dont get the Guide.. not good in english

[latruwski]

do i need to download them all?

you are really confused... this is a guide on how to make 1sql file out of multiple sql files...
I dont know what you want!? If you wnt to create a server read the guides posted here on how to do that
If you wnt to have the lastest ncdb database when you create a sever then yes you have to download them all... but i suggest you read the guides first cuz you seem to be verry confused...

grtz

[latruwski]

i dont get the Guide.. not good in english

what language you speak? maybe someone one the forum is speaking that too

[condoom]

i speak Dutch , and yes i'm really confused , the private server that i made wont work ,, you know .

[latruwski]

i speak Dutch , and yes i'm really confused , the private server that i made wont work ,, you know .

dam you are lucky ! i speak dutch too rofl i made a pack that works perfectly everything is preconfigured... you only need to make a database called latruwski and start the exe's :P
anyhow add me on msn: [email protected]
i'll help you out

grtz

[~ViVo~]

Dang this is epic