EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Script for Fast Player Backups (https://www.eqemulator.org/forums/showthread.php?t=33589)

Sikkun 05-19-2011 02:44 AM

Script for Fast Player Backups
 
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


All times are GMT -4. The time now is 09:37 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.