That really just depends on how well you know SQL. I dump our DB once every hour just in case a screw up would happen.
Now if you are talking a massive edit for a zone useually we backup the parts that are important like for instance doing a zones spawns. We'll back up grid, grid entries, spawn2, spawnentry, and just in cause npc_types which match spawnentry. Only really had to do that three times.
But other wise a good idea is to install the default db to like peq2 in mysql so you have a copy of it and you can just find what you need if you do bork something.
|