Creating SQL files.

[Linkn]

Alright I am currently in the process of making a raid on Alcaz Island and was wondering how I could make an SQL file or something to dump all the npcs on Alcaz Island into one file so people could download it. Like any other release you download the SQL's and execute them into navicat etc. Thats what i need to do. Hope this makes sense.

[Linkn]

Thanks! +Rep for the help

[Reflection]

I usually dump the table I need then manually open it with notepad and erase everything up to the first one where I see the mapID, coordinates or something which is right where I spawned them. The ones after that is the ones I want

A tip to make it even easier is if you for example spawn a mob in Kalimdor but before you spawn it you spawn one in Eastern Kingdoms, thus the mapid is 0 or 1 being which one you spawned at. Then all the ones after will have mapid 0 if you spawned at 1 and the other way around.

[Linkn]

I usually dump the table I need then manually open it with notepad and erase everything up to the first one where I see the mapID, coordinates or something which is right where I spawned them. The ones after that is the ones I want

A tip to make it even easier is if you for example spawn a mob in Kalimdor but before you spawn it you spawn one in Eastern Kingdoms, thus the mapid is 0 or 1 being which one you spawned at. Then all the ones after will have mapid 0 if you spawned at 1 and the other way around.

Thanks for the replies One more question.. could this whole procedure be done for game objects as well? I would assume so but want to clarify it.

[InvaderGir]

Yes, just Dump whole your World database and thats it

[Linkn]

And delete whats unnecessary of course

[Pedregon]

This is what I do.
Do a sql dump of just the tables "creature_spawns" and "gobject_spawns"
before the changes,and do the same after.
When your done just copy the changes into notepad and save it as name.sql
.sql has to be at the end.