List:MySQL on Win32« Previous MessageNext Message »
From:Matías Castilla Date:October 7 2005 3:16pm
Subject:RE: backup
View as plain text  
very useful help, thanks

-----Mensaje original-----
De: Jason Dimberg [mailto:jason.dimberg@stripped]
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=1

Thread
backupMatías Castilla5 Oct
  • Re: backupJason Dimberg7 Oct
    • RE: backupMatías Castilla7 Oct