Sikkun
05-19-2011, 02:44 AM
Because of the new Beta Release I wrote this real quick, it is based off the drop_player.sql. Just replace user name/password with your own and copy and paste into the command window. Then after updating your database source in the player_backup.sql file you just created. This will also allow you to backup your players quickly incase of data loss.
mysqldump -uusername -ppassword peq --tables aa_timers account account_ip account_rewards adventure_details adventure_members adventure_stats Banned_IPs bugs buyer char_recipe_list character_ character_activities character_enabledtasks character_tasks character_backup chatchannels commands completed_tasks 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 mail merchantlist_temp name_filter object_contents petitions player_corpses player_corpses_backup player_titlesets quest_globals raid_details raid_members reports respawn_times rule_sets rule_values sharedbank spell_globals timers trader trader_audit variables zone_flags db_version > c:\player_backup.sql
mysqldump -uusername -ppassword peq --tables aa_timers account account_ip account_rewards adventure_details adventure_members adventure_stats Banned_IPs bugs buyer char_recipe_list character_ character_activities character_enabledtasks character_tasks character_backup chatchannels commands completed_tasks 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 mail merchantlist_temp name_filter object_contents petitions player_corpses player_corpses_backup player_titlesets quest_globals raid_details raid_members reports respawn_times rule_sets rule_values sharedbank spell_globals timers trader trader_audit variables zone_flags db_version > c:\player_backup.sql