PDA

View Full Version : automatic restore last backup



shamim007
June 25th, 2008, 07:15 PM
Hi,
1. I want to take backup from remote machine to my local machine. I completed that. Now I want to restore the last backup file to my local machine.
Is it possible automatically restore the last backup ?


2. How can I on the binary log file ? I set the parameter as follows ...

mysql-binlog-path="/var/log/mysql-zrm"

can any one help me ??
thanks

shamim007
June 27th, 2008, 01:26 AM
hi
I solved it by writing a shell script . I enter this shell script into my crontab. Now it is take backup from remote machine and restore to my local machine in certain time interval as I mention in crontab .

thanks

kulkarni_mangesh
June 27th, 2008, 04:20 AM
Another way is to use "last_backup". This is normally kept at location, /etc/mysql-zrm/_BKP_SET_NAME_/last_backup. which maintains where mysql-zrm has taken a backup.