Zaloha ACC

[smoke 0]

PLS poradte co mam zle v Source kod mam toto

@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=C:\Program Files\MySQL\MySQL Server 5.0\bin\

set zaloha=%datum2%

REM --------------------------------

REM -------Zacatek nastaveni--------

REM --------------------------------

set uzivatel=root

set heslo=root

set rdb=realmd

set mdb=mangos

REM --------------------------------

REM --------Konec nasteveni---------

REM --------------------------------

set mangosdb=mangos-zaloha_%Time%.sql

set realmddb=realmd-zaloha_%Time%.sql

 

set bu1="account"

set bu2="auctionhouse character character_action character_aura character_homebind character_inventory character_kill character_pet character_queststatus character_reputation character_social character_spell character_ticket character_tutorial character_pet guild guild_member guild_rank item_instance mail corpse guild_charter guild_charter_sign"

 

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%" > "%zaloha%"\"%mangosdb%"

 

cls

color 1A

@echo Zaloha uspesne vytvorena !

@echo Edited by Replik

@echo Thanks Benny

set uzivatel=

set heslo=

set rdb=

set mdb=

set mangosdb=

set realmddb=

set bu1=

set bu2=

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 mangosdb=

set realmddb=

set bu1=

set bu2=

exit

 

:EXIT

color 07

exit

 

A spravi mi to dva textaky Mangos zaloha a realmd zaloha ale su prazdne.

Dik za radu

[Replik 2]

Špatné nastavení připojení k DB - nebo špatně nadefinovaný seznam tabulek.