View Single Post
  #5  
Old 04-24-2014, 10:50 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,072
Default

Quote:
Originally Posted by NEEDADISPENSERHERE View Post
Hey Esildor, thanks for the response!

The thing is, I only want to backup my accounts, characters, and items (and things associated, like bank etc.) I think I read in the forums *what* to back up, so I seem to have that covered, I'm just not sure how.

Your suggestion backs up the entire database right? Unfortunately, I screwed up mine when updating it somehow. Rather than causing myself a headache and taking up a lot of forumer's time, I figured just backing up the aforementioned stuff and restarting the database would be better.

I do appreciate the response though.
Very coincidentally I am working on a script that does this very thing. In the meantime do to specific tables you can do something like this:

Below is what is considered 'player tables'

%1 is where your username goes, %2 is your database - sorry EDIT. Your password can go right next do the -p though. -pPassword.

Code:
echo off
mysqldump -u %1 -p %2 aa_timers account account_ip account_rewards adventure_details adventure_members adventure_stats Banned_IPs bugs buyer char_recipe_list character_ character_activities character_alt_currency character_buffs character_enabledtasks character_tasks character_backup character_pet_info character_pet_buffs character_pet_inventory chatchannels commands completed_tasks discovered_items eventlog faction_values friends gm_ips group_id guild_bank group_leaders guild_members guild_ranks guild_relations guilds hackers inventory instance_lockout instance_lockout_player keyring launcher launcher_zones lfguild mail merchantlist_temp name_filter object_contents petitions player_corpses player_corpses_backup player_titlesets quest_globals raid_details raid_members reports respawn_times sharedbank spell_globals timers trader trader_audit variables zone_flags db_version > playertables.sql

Last edited by Akkadius; 04-24-2014 at 11:01 PM..
Reply With Quote