MySQL Forums
Forum List  »  Spanish

Re: mysqldump remoto
Posted by: deivis Crisanto Gonzales
Date: March 26, 2013 11:59PM

JESUS ​​Uzcanga gracias por tu ayuda.
al final termine por configurar un archivo bat para sacar dumps automaticamente comparto el script.

@echo off
FOR /F "tokens=1,2,3 delims=/ " %%i IN ('date /T') do (set DIA= %%k%%j%%i)
FOR /F "tokens=1,2 delims=: " %%n IN ('time /T') do (set HORA= %%n%%o)

md "D:\BACK-OCTI\%dia%_%hora%"

"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump" -u mysql -pmysql -h 172.16.1.56 --opt -R octi > "D:\BACK-OCTI\%dia%_%hora%\octi_%dia%_%hora%.sql"


saludos.

Options: ReplyQuote


Subject
Views
Written By
Posted
3243
January 02, 2013 08:47PM
1428
January 03, 2013 09:30AM
Re: mysqldump remoto
952
March 26, 2013 11:59PM
939
March 27, 2013 02:40PM
1183
January 03, 2013 05:08PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.