Ahoj lidi, trošku jsem upravil ten prográmek, už nebude zálohovat jen realmd a mangos ale i characters a SD2.
Je to psaný pro 2 servery mangos, characters a sd2
U nastavení smažte a nahraďte vašemi informacemi
$cesta k SQL Serveru
$uživatelské jméno
$heslo uživatele
@echo off
set datum=%date%
set datum1=%date: =-%
set datum2=%datum1:.=-%
@echo off
for /F "tokens=1-4 delims=:., " %%a in ('time/T') do set Time=%%ah-%%bmin
@echo off
color 18
title Zalohovani accountu a postav pro Mangos /by Replik
set mysqlbin=$cesta k SQL Serveru
set zaloha=%datum2%
REM --------------------------------
REM -------Zacatek nastaveni--------
REM --------------------------------
set uzivatel=$uživatelské jméno
set heslo=$heslo uživatele
set rdb=realmd
set mdb=mangos
set mdb2=mangos2
set chdb=characters
set chdb2=characters2
set sd2db=scriptdev2
set sd2sdb=scriptdev2s
REM --------------------------------
REM --------Konec nasteveni---------
REM --------------------------------
set mangosdb=mangos-zaloha_%Time%.sql
set mangosdb2=mangos2-zaloha_%Time%.sql
set charactersdb=characters-zaloha_%Time%.sql
set charactersdb2=characters2-zaloha_%Time%.sql
set scriptdev2db=scriptdev2-zaloha_%Time%.sql
set scriptdev2sdb=scriptdev2s-zaloha_%Time%.sql
set realmddb=realmd-zaloha_%Time%.sql
set bu1="account realmcharacters realmlist ip_banned"
set bu2.1="auctionhouse corpse guild petition petition_sign guild_member guild_rank 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 instance item_instance mail"
set bu2.2="auctionhouse corpse guild petition petition_sign guild_member guild_rank 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 instance item_instance mail"
if not exist "%mysqlbin%mysqldump.exe" goto ERROR1
if not exist "%zaloha%" mkdir %datum2%
"%mysqlbin%mysqldump" --user=%uzivatel% --password=%heslo% --add-drop-table %rdb% "%bu1%" > "%zaloha%"\"%realmddb%"
"%mysqlbin%mysqldump" --user=%uzivatel% --password=%heslo% --add-drop-table %mdb% "%bu2.1%" > "%zaloha%"\"%mangosdb%"
"%mysqlbin%mysqldump" --user=%uzivatel% --password=%heslo% --add-drop-table %mdb2% "%bu2.2%" > "%zaloha%"\"%mangosdb2%"
"%mysqlbin%mysqldump" --user=%uzivatel% --password=%heslo% --add-drop-table %chdb% "%bu3.1%" > "%zaloha%"\"%charactersdb%"
"%mysqlbin%mysqldump" --user=%uzivatel% --password=%heslo% --add-drop-table %chdb2% "%bu3.2%" > "%zaloha%"\"%charactersdb2%"
"%mysqlbin%mysqldump" --user=%uzivatel% --password=%heslo% --add-drop-table %sd2db% "%bu4.1%" > "%zaloha%"\"%scriptdev2db%"
"%mysqlbin%mysqldump" --user=%uzivatel% --password=%heslo% --add-drop-table %sd2sdb% "%bu4.2%" > "%zaloha%"\"%scriptdev2sdb%"
cls
color 1A
@echo Zaloha uspesne vytvorena !
@echo Edited by Replik
@echo Thanks Benny
set uzivatel=
set heslo=
set rdb=
set mdb=
set mdb2=
set chdb=
set chdb2=
set sd2db=
set sd2sdb=
set mangosdb=
set mangosdb2=
set charactersdb=
set charactersdb2=
set scriptdev2db=
set scriptdev2sdb=
set realmddb=
set bu1=
set bu2=
set bu2.1=
set bu2.2=
set bu3.1=
set bu3.2=
set bu4.1=
set bu4.2=
goto EXIT
:ERROR1
cls
color 1C
echo ***************************** ERROR *********************************
echo Nemohu najit %mysqlbin%mysqldump.exe
echo Mate nainstalovany MySQL? Ujistete se, ze neni poskozen.
echo Popripade jej nainstalujte.
echo *********************************************************************
set uzivatel=
set heslo=
set rdb=
set mdb=
set mdb2=
set chdb=
set chdb2=
set sd2db=
set sd2sdb=
set mangosdb=
set mangosdb2=
set charactersdb=
set charactersdb2=
set scriptdev2db=
set scriptdev2sdb=
set realmddb=
set bu1=
set bu2.1=
set bu2.2=
set bu3.1=
set bu3.2=
set bu4.1=
set bu4.2=
pause
exit
:EXIT
color 07
exit