Results 1 to 3 of 3

Thread: automatic restore last backup

  1. #1

    Question automatic restore last backup

    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
    Last edited by shamim007; June 26th, 2008 at 04:36 PM.

  2. #2

    Thumbs up

    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

  3. #3

    Default

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •