魔兽mangos系统用户数据自动备份Linux脚本

#!/bin/bash

USER=<USERNAME>
PASS=<PASSWORD>
DBNAME=mangos
RNAME=realmd

clear
echo"BACKINGUPACCOUNTSPHASE1...(REALMDDATABASE)"
mysqldump--user=${USER}--password=${PASS}--opt${RNAME}accountaccount_bannedip_bannedrealmcharactersrealmlist>`date+%m-%d-%y`realmd_char.sql
echo"BACKINGUPACCOUNTSPHASE2...(MANGOSDATABASE)"
mysqldump--user=${USER}--password=${PASS}--opt${DBNAME}arena_teamarena_team_memberarena_team_statsauctionhousecharactercharacter_actioncharacter_auracharacter_giftscharacter_homebindcharacter_instancecharacter_inventorycharacter_killcharacter_petcharacter_queststatuscharacter_reputationcharacter_socialcharacter_spellcharacter_spell_cooldowncharacter_ticketcharacter_tutorialcorpsegroupgroup_memberguildguild_memberguild_rankinstanceitem_instanceitem_textmail>`date+%m-%d-%y`mangos_char.sql
echo"BACKUPCOMPLETED!"

windows

@ECHOOFF
setdatum=%date%
setdatum1=%date:=-%
setdatum2=%date1:.=-%

@echooff
for/F"tokens=1-4delims=:."%%ain('time/T')dosetTime=%%ah-%%bmin

SETDBUSER=DATABASEUSERNAME
SETDBPASS=YOURPASSOFFCOURSE
SETMDBNAME=mangos
SETRDBNAME=realmd
SETMYPATH="D:\apache2triad\mysql\bin\mysqldump.exe"
setbackup=%date2%

ECHOEXPORTINGACCOUNTSBA​