backup

Do you know where could I find info about mysqlbackup script to run it in a
Win2000 server?
matías


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: backup

Matías Castilla wrote:

>Do you know where could I find info about mysqlbackup script to run it in a
>Win2000 server?
>matías
>
>
>
>
Here's my backup.bat file I run with scheduler:
-------
"C:\mysqldump.exe" -A -C -v -h [server address] -u [uname] -p[password]
-r c:\mysql.sql

echo on
@REM Seamonkey's quick date batch (MMDDYYYY format)
@REM Setups %date variable
@REM First parses month, day, and year into mm , dd, yyyy formats and
then combines to be MMDDYYYY

FOR /F "TOKENS=1* DELIMS= " %%A IN ('DATE/T') DO SET CDATE=%%B
FOR /F "TOKENS=1,2 eol=/ DELIMS=/ " %%A IN ('DATE/T') DO SET mm=%%B
FOR /F "TOKENS=1,2 DELIMS=/ eol=/" %%A IN ('echo %CDATE%') DO SET dd=%%B
FOR /F "TOKENS=2,3 DELIMS=/ " %%A IN ('echo %CDATE%') DO SET yyyy=%%B
SET date=%mm%%dd%%yyyy%

ren c:\mysql.sql "%date%_mysql.sql"
------

Jason

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: backup

very useful help, thanks

-----Mensaje original-----
De: Jason Dimberg [mailto:jason.dimberg@rmpcorp.com]
Enviado el: Viernes, 07 de Octubre de 2005 01:17
CC: MySQL-Win32
Asunto: Re: backup




Matías Castilla wrote:

>Do you know where could I find info about mysqlbackup script to run it in a
>Win2000 server?
>matías
>
>
>
>
Here's my backup.bat file I run with scheduler:
-------
"C:\mysqldump.exe" -A -C -v -h [server address] -u [uname] -p[password]
-r c:\mysql.sql

echo on
@REM Seamonkey's quick date batch (MMDDYYYY format)
@REM Setups %date variable
@REM First parses month, day, and year into mm , dd, yyyy formats and
then combines to be MMDDYYYY

FOR /F "TOKENS=1* DELIMS= " %%A IN ('DATE/T') DO SET CDATE=%%B
FOR /F "TOKENS=1,2 eol=/ DELIMS=/ " %%A IN ('DATE/T') DO SET mm=%%B
FOR /F "TOKENS=1,2 DELIMS=/ eol=/" %%A IN ('echo %CDATE%') DO SET dd=%%B
FOR /F "TOKENS=2,3 DELIMS=/ " %%A IN ('echo %CDATE%') DO SET yyyy=%%B
SET date=%mm%%dd%%yyyy%

ren c:\mysql.sql "%date%_mysql.sql"
------

Jason

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:
http://lists.mysql.com/win32?unsub=matias.castilla@hospitali taliano.org.ar


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org