|魔兽服务端用户数据自动备份脚本

【|魔兽服务端用户数据自动备份脚本】

魔兽mangos用户数据自动备份脚本
#!/bin/bashUSER=<USERNAME>PASS=<PASSWORD>DBNAME=mangosRNAME=realmdclearecho \"BACKING UP ACCOUNTS PHASE 1...(REALMD DATABASE)\"mysqldump --user=${USER --password=${PASS --opt ${RNAME account account_banned ip_banned realmcharacters realmlist > `date +%m-%d-%y`realmd_char.sqlecho \"BACKING UP ACCOUNTS PHASE 2...(MANGOS DATABASE)\"mysqldump --user=${USER --password=${PASS --opt ${DBNAME arena_team arena_team_member arena_team_stats auctionhouse character character_action character_aura character_gifts character_homebind character_instance character_inventory character_kill character_pet character_queststatus character_reputation character_social character_spell character_spell_cooldown character_ticket character_tutorial corpse group group_member guild guild_member guild_rank instance item_instance item_text mail > `date +%m-%d-%y`mangos_char.sqlecho \"BACKUP COMPLETED!\"windows@ECHO OFFset datum=%date%set datum1=%date: =-%set datum2=%date1:.=-%@echo offfor /F \"tokens=1-4 delims=:. \" %%a in ('time/T') do set Time=%%ah-%%bminSET DBUSER=DATABASE USERNAMESET DBPASS=YOUR PASS OFFCOURSESET MDBNAME=mangosSET RDBNAME=realmdSET MYPATH=\"D:\\apache2triad\\mysql\\bin\\mysqldump.exe\"set backup=%date2%ECHO EXPORTING ACCOUNTS BA