Quote:
Originally Posted by NEEDADISPENSERHERE
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
Hybrid Mode
