Export Zone data from DB

[jpyou127]

I am wondering if there is a way to export the zone data from a DB. Everything that makes the zone work: doors, objects, NPCs, etc.. into an SQL file that could be imported into another DB.


Celestial

[Akkadius]

I am wondering if there is a way to export the zone data from a DB. Everything that makes the zone work: doors, objects, NPCs, etc.. into an SQL file that could be imported into another DB.


Celestial

No

/10char

[Shendare]

Right. No-one's written a program to go through all the tables and package up their contents by individual zones. Things like NPCTypes, SpawnGroups, Spawn2 locations, interact in a way that makes separating out by zone a complicated endeavor.

[Akkadius]

http://www.eqemulator.org/forums/showthread.php?t=38048&highlight=universaL

[Shendare]

Awesome! So it's been on the radar, just hasn't been able to be done yet.

[jpyou127]

Yep that would be awesome!!

Celestial

[N0ctrnl]

I actually do this all the time using the zone import/export tool in EoC. As part of the operations, it prints what it's done at the bottom of the page. You can use that inserted into a fresh DB to get what you're after.

Edit: It is worth noting that loot tables don't get exported, so that's a thing.