i1010101
04-04-2010, 05:20 AM
Hello. I've been looking through things trying to get straight how to back up my lan server's accounts, characters, and bots. Basically, I want to do something comparable to the technique in this thread (http://www.eqemulator.org/forums/showthread.php?t=27545) (obviously, the information there is out of date, but the concept is still sound).
I'll start by saying I'm using EQEmu-Rev1316-Bots.rar (http://projecteqemu.googlecode.com/files/EQEmu-Rev1316-Bots.rar) with peqdatabase-Rev1265.zip (http://projecteqdb.googlecode.com/files/peqdatabase-Rev1265.zip) and 1280_bot_augs.sql (http://code.google.com/p/projecteqemu/source/browse/trunk/EQEmuServer/utils/sql/svn/1280_bot_augs.sql) applied to it. Though I suppose it isn't important to my question, I'm also using peqquests-Rev1264.zip (http://projecteqquests.googlecode.com/files/peqquests-Rev1264.zip).
I'm 99% sure I need to keep the following tables if I'm to keep the accounts, characters, and bots intact:
botbuffs
botgroup
botgroupmembers
botguildmembers
botinventory
botpetbuffs
botpetinventory
botpets
bots
character_
character_activities
character_backup
character_enabledtasks
character_tasks
chatchannels
completed_tasks
faction_values
friends
graveyard
guilds
guild_members
guild_ranks
guild_relations
inventory
keyring
mail
pets
player_corpses
player_corpses_backup
player_titlesets
quest_globals
sharedbank
zoneflags
Then there are a couple that I'm not sure I need. Looking at them, they look like they might be important to my purposes, but I'm not sure. What are these tables for?
timers
vwbotcharactermobs
vwbotgroups
vwbotguildmembers
Have I missed any tables? Do I need the four I'm unsure about? Do I not need some of those tables I'm 99% sure I do need?
Thanks for any responses :)
I'll start by saying I'm using EQEmu-Rev1316-Bots.rar (http://projecteqemu.googlecode.com/files/EQEmu-Rev1316-Bots.rar) with peqdatabase-Rev1265.zip (http://projecteqdb.googlecode.com/files/peqdatabase-Rev1265.zip) and 1280_bot_augs.sql (http://code.google.com/p/projecteqemu/source/browse/trunk/EQEmuServer/utils/sql/svn/1280_bot_augs.sql) applied to it. Though I suppose it isn't important to my question, I'm also using peqquests-Rev1264.zip (http://projecteqquests.googlecode.com/files/peqquests-Rev1264.zip).
I'm 99% sure I need to keep the following tables if I'm to keep the accounts, characters, and bots intact:
botbuffs
botgroup
botgroupmembers
botguildmembers
botinventory
botpetbuffs
botpetinventory
botpets
bots
character_
character_activities
character_backup
character_enabledtasks
character_tasks
chatchannels
completed_tasks
faction_values
friends
graveyard
guilds
guild_members
guild_ranks
guild_relations
inventory
keyring
pets
player_corpses
player_corpses_backup
player_titlesets
quest_globals
sharedbank
zoneflags
Then there are a couple that I'm not sure I need. Looking at them, they look like they might be important to my purposes, but I'm not sure. What are these tables for?
timers
vwbotcharactermobs
vwbotgroups
vwbotguildmembers
Have I missed any tables? Do I need the four I'm unsure about? Do I not need some of those tables I'm 99% sure I do need?
Thanks for any responses :)