Updating Database

[AsmoTiC]

Just a follow up, incase anybody searches and finds this post.

There may be an easier way, if there is, perhaps someone can chime in.

Using Heidi I found my custom entries and using the right-click context menu exported the grid to an SQL file. For anybody that's interested, you are given the option to export as a new entry, or a replacement entry. So in the case of my Sirens Grotto safe point change, I used a replace; where the new item and merchantlist entries were inserts (new).

As far as the server rules go, I ended up just exporting the whole "rule_values" table to a SQL file all it's own.

Anyway, from there the process was simply; source "drop_system.sql", source "peqbeta.sql", source "custom.sql" (the file created above), and finally source "rules.sql". No errors/warnings/etc. Pretty clean process, something easy enough to do each time you'd like to update to the newest PEQ dump. Even easier if you stay ontop of the DB changes as you make them and just keep the custom.sql current.

Now with all that said, I did have one problem. Hopefully someone could offer advice. My two new NPC's didn't update, so I ended up reverting back to my backup. What all tables do I need to export so they are in the world? I exported each npc from the "npc_types" table, I exported both "spawngroup" values, and both "spawnentry" values. When I restarted the server and checked on them, they wern't up. Did I miss a table somewhere?

Hopefully this will help someone who has custom entries in the DB, but still wants to stay current with PEQ.

[AsmoTiC]

Originally Posted by AsmoTiC

Now with all that said, I did have one problem. Hopefully someone could offer advice. My two new NPC's didn't update, so I ended up reverting back to my backup. What all tables do I need to export so they are in the world? I exported each npc from the "npc_types" table, I exported both "spawngroup" values, and both "spawnentry" values. When I restarted the server and checked on them, they wern't up. Did I miss a table somewhere?

Incase anybody ever uses this as a rough guide for doing the same type of thing, I figured i'd post back what I did to fix my two missing NPCS.

Sure enough I missed the entries in the "spawn2" table. Once I exported them and merged them into the custom.sql, the whole process ended up working out. So if you have custom NPC's you want to save you'll need to grab the NPC data, and all Spawn data.

Here are the tables that had everything associated with them:
npc_types, spawngroup, spawnentry, and spawn2.

Again, ended up answering all my own questions over the course of a couple days. Hopefully anybody that does a search will find the thread and get some direction from it.