I don't have the exact expertise on how to do this, but there are a few ways depending on your knowledge of mysql and databases.
Before you start anything, make a backup of your original database in case something happens.
If it were me, I'd have another computer setup with mysql and then source in a new peq database.
In this new database, delete all other peq tables but the ones you need info from. Then, delete all other entries in those tables but the ones you need. This should leave you with only the information you're looking for.
I can't remember which programs let you create a source file, but you should be able to create a .sql file that can be used to update your original database.
-- \/ or \/ --
Try out-sourcing only the tables you need and then editing that file to remove everything but zone mobs/npcs that you need.
-- /\ /\ --
If you make it this far, on that second computer create a second database called test, or whatever you choose. Source in another new database and delete the information that was lost in the original one. This will give you a copy on which to test this source file.
'Use' the test database and source in this new file. Check to see if the source took properly without corrupting the other data.
If this worked, you might consider creating a temp eqemu server on this second computer and testing the database validity before trying it on your original.
I can't say if this will work, but these are the steps I would look at taking if I had this problem. Database versions could be a problem if you're using an older database.
Hopefully someone else can help to shed some light on this.
(Grabbing info out of the original peqdb.sql might work as well, but I don't have the patience to search through that much info.)
|
Threaded Mode
