Soft na zálohy MySQL

[Warmaniac 0]

Neviete niekto o nejakom free softe na zalohu mysql DB ? Najlepsie keby boli nastavitelne intervaly zalohy , vsetko co som nasiel je plateny soft... Dikes

[bbtrash 18]

Neviete niekto o nejakom free softe na zalohu mysql DB ? Najlepsie keby boli nastavitelne intervaly zalohy , vsetko co som nasiel je plateny soft... Dikes

Cron prikazovy radek a mysqldump ?

[K.I.L.L.E.R 2]

Neviete niekto o nejakom free softe na zalohu mysql DB ? Najlepsie keby boli nastavitelne intervaly zalohy , vsetko co som nasiel je plateny soft... Dikes

 

Pro win nebo Linux? Pokud mas Win, tak se koukni na jeden z mých prispevku a najdes na to mnou udelany script..

[Warmaniac 0]

lenze vase skripty su vacsionou zastarale a nezalohuju vsetky table... mam Win

[Flora 1]

tak ty table co tam sou napsane si smaz a napiš si tam svoje... jednoduche.... proste si tam napiš co chceš bay se zalohovalo... ja sem si to udelal taky

 

tam kde je set bu1 -- realmd a setbu2 character.... prepis si to jak chces---ja použivam to co tam mam a funguej v poho

kdyztak tu to mas:

@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=characters
REM --------------------------------
REM --------Konec nasteveni---------
REM --------------------------------
set mangosdb=characters-zaloha_%Time%.sql
set realmddb=realmd-zaloha_%Time%.sql

set bu1="account realmcharacters realmlist ip_banned"
set bu2="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%" > "%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=
pause
exit

:EXIT
color 07
exit

Edited October 29, 2008 by Flora

[chronos 28]

Dobrý námět pro novou stránku do wiki a to jak pro win tak i pro linux.