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

艾西ONEPIECE 03-30 120

前言：

而今咱们对“魔兽世界单机版apache”大致比较珍视，姐妹们都需要知道一些“魔兽世界单机版apache”的相关内容。那么小编在网上搜集了一些有关“魔兽世界单机版apache””的相关知识，希望咱们能喜欢，各位老铁们一起来了解一下吧！

魔兽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