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

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

 

#!/bin/bash

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

clear
echo "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.sql
echo "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.sql
echo "BACKUP COMPLETED!"


windows

@ECHO OFF
set datum=%date%
set datum1=%date: =-%
set datum2=%date1:.=-%

@echo off
for /F "tokens=1-4 delims=:., " %%a in ('time/T') do set Time=%%ah-%%bmin

SET DBUSER=DATABASE USERNAME
SET DBPASS=YOUR PASS OFFCOURSE
SET MDBNAME=mangos
SET RDBNAME=realmd
SET MYPATH="D:\apache2triad\mysql\bin\mysqldump.exe"
set backup=%date2%

ECHO EXPORTING ACCOUNTS BA​