How do I save my spawns?

[neosar]

Hi,

I am running ArcEmu & NCDB8. I've spawned a mini-mall in the entrance to stormwind using some vendors that were posted on this site. My question is, I want to now update to NCDB9, and I'd rather not manually respawn all these vendors. I'd like to know how I can get sql file dumps of the vendor spawns so I can patch them into my new database. I don't mind doing this one by one for each vendor so that in the future I can quickly patch them into updates.

Any help would be greatly appreciated.

[Reflection]

Dump the creature_spawns table in your database.

[neosar]

But if I update the entire database, and then dump the old version of that table back into the database aren't I losing all the changes that the NCDB team made to that table from 8 to 9?

[neosar]

SOLVED: Sort creature_spawns by index, and export the highest numbers (the ones I created) to an SQL file.