GeorgeS: Dedicated character backup-restore tool

[Angelox]

Thanks John, so probably if the person was using only ax_peq for the server, he would only need back up/restore The first codeblock;

use ax_peq;

DROP TABLE IF EXISTS aa_timers;
DROP TABLE IF EXISTS account;
DROP TABLE IF EXISTS character_;
DROP TABLE IF EXISTS character_backup;
DROP TABLE IF EXISTS commands;
DROP TABLE IF EXISTS eventlog;
DROP TABLE IF EXISTS faction_values;
DROP TABLE IF EXISTS guilds;
DROP TABLE IF EXISTS guild_ranks;
DROP TABLE IF EXISTS guild_relations;
DROP TABLE IF EXISTS guild_members;
DROP TABLE IF EXISTS guild_alliances;
DROP TABLE IF EXISTS guild_controllers;
DROP TABLE IF EXISTS hackers;
DROP TABLE IF EXISTS inventory;
DROP TABLE IF EXISTS launcher;
DROP TABLE IF EXISTS launcher_zones;
DROP TABLE IF EXISTS logs;
DROP TABLE IF EXISTS name_filter;
DROP TABLE IF EXISTS object_contents;
DROP TABLE IF EXISTS peq_admin;
DROP TABLE IF EXISTS petitions;
DROP TABLE IF EXISTS player_corpses;
DROP TABLE IF EXISTS player_corpses_backup;
DROP TABLE IF EXISTS quest_globals;
DROP TABLE IF EXISTS rule_sets;
DROP TABLE IF EXISTS rule_values;
DROP TABLE IF EXISTS variables;
DROP TABLE IF EXISTS spells;
DROP TABLE IF EXISTS sharedbank;
DROP TABLE IF EXISTS timers;

and have a backup of his original tables -
Maybe GeorgeS can simplify this in a new tool, I'd be glad to test it.
These look like all the tables needed.

[Angelox]

It just dawned on me;
I can easily make a "patch" version of the db;
Start with this;

use peq;

DROP TABLE IF EXISTS aa_actions;
DROP TABLE IF EXISTS aa_levels;
DROP TABLE IF EXISTS aa_swarmpets;
DROP TABLE IF EXISTS altadv_vars;
DROP TABLE IF EXISTS books;
DROP TABLE IF EXISTS class_skill;
DROP TABLE IF EXISTS doors;
DROP TABLE IF EXISTS faction_list;
DROP TABLE IF EXISTS fear_hints;
DROP TABLE IF EXISTS fishing;
DROP TABLE IF EXISTS forage;
DROP TABLE IF EXISTS grid;
DROP TABLE IF EXISTS grid_entries;
DROP TABLE IF EXISTS ground_spawns;
DROP TABLE IF EXISTS items;
DROP TABLE IF EXISTS lootdrop;
DROP TABLE IF EXISTS lootdrop_entries;
DROP TABLE IF EXISTS loottable;
DROP TABLE IF EXISTS loottable_entries;
DROP TABLE IF EXISTS merchantlist;
DROP TABLE IF EXISTS merchantlist_temp;
DROP TABLE IF EXISTS merchantsets;
DROP TABLE IF EXISTS npc_faction;
DROP TABLE IF EXISTS npc_faction_entries;
DROP TABLE IF EXISTS npc_spells;
DROP TABLE IF EXISTS npc_spells_entries;
DROP TABLE IF EXISTS npc_types;
DROP TABLE IF EXISTS object;
DROP TABLE IF EXISTS pets;
DROP TABLE IF EXISTS spawn2;
DROP TABLE IF EXISTS spawn_conditions;
DROP TABLE IF EXISTS spawn_events;
DROP TABLE IF EXISTS spawnentry;
DROP TABLE IF EXISTS spawngroup;
DROP TABLE IF EXISTS start_zones;
DROP TABLE IF EXISTS starting_items;
DROP TABLE IF EXISTS tradeskill_recipe;
DROP TABLE IF EXISTS tradeskill_recipe_entries;
DROP TABLE IF EXISTS traps;
DROP TABLE IF EXISTS tribute_levels;
DROP TABLE IF EXISTS tributes;
DROP TABLE IF EXISTS zone;
DROP TABLE IF EXISTS zone_points;
DROP TABLE IF EXISTS zone_server;
DROP TABLE IF EXISTS zone_state_dump;
DROP TABLE IF EXISTS zoneserver_auth;
DROP TABLE IF EXISTS zone_flags;

Then have a dump of all these tables from the updated database ready to follow and replace?

[sesmar]

What I usually do when I get a new version of the DB, such as Angelox's db is something similar to what has been posted here.

I use the base PEQ drop_users.sql script to find all the tables that are related to users. Then I just open up MySql Administrator and create a backup job that backs up those tables. Once I run that job I will open up the SQL script that it creates and find the first reference to the Database name (usually close to top of the file.) So if the Database was named peq I will look for the 'use peq' statement and then I do a find and replace on all instances of peq with my new database name (such as peq to ax_peq). Now all you have to do is restore the backup file and you are all done.

[Angelox]

I used John Adams post and made an "update" sql, that should update just what's needed, and nothing else. I know I should of thought of this before, as it is a simple solution. But I always make "mental blocks for myself.
I tried it out, seems ok if anyone wants to try, it's posted.
Thanks for the as usual help you all give me.

[John Adams]

Just don't forget your peq_admin, and rules* related tables that are not in the base drop_users.sql script (unless it's been added since my d/l on 7/16).

I think those are the only additional server-specific tables added since peq-luclin-rc1.

[sesmar]

Originally Posted by John Adams

Just don't forget your peq_admin, and rules* related tables that are not in the base drop_users.sql script

Yes, as well as the new guild related tables.