linux mangos创建账号,魔兽mangos系统用户数据自动备份Linux脚本

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

来源：

作者：

点击：

#!/bin/bash

USER=

PASS=

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​