Results 1 to 4 of 4

Thread: complete point in time recovery.

  1. #1

    Default complete point in time recovery.

    Hi All,
    I have only tested the Zmanda backup and recovery in 15 Min using this url
    [url]http://www.zmanda.com/quick-mysql-backup.html[/url].

    This was basically a bump backup and restore method.

    Does Zmanda does not provide auto restore/recovery till the point of failure based on the bin-logs.

    Also, please provide you feedback if we can use this software for our database which runs 24/7.

    regards
    anandkl

  2. #2
    Join Date
    Oct 2006
    Posts
    199

    Default

    Quote Originally Posted by ananda View Post
    Hi All,
    I have only tested the Zmanda backup and recovery in 15 Min using this url
    [url]http://www.zmanda.com/quick-mysql-backup.html[/url].

    This was basically a bump backup and restore method.

    Does Zmanda does not provide auto restore/recovery till the point of failure based on the bin-logs.

    Also, please provide you feedback if we can use this software for our database which runs 24/7.

    regards
    anandkl
    Hi,

    You can do the restore in a 3 step process as of today. These steps are

    a) First do the restore from the full backup
    b) Restart mysql server if needed
    c) Restore all of the binary logs at one go using the --bin-logs, the --start-datetime and/or stop-datetime options.

    ZRM is meant for backup of live databases so I think you should be able to use ZRM for your needs..

  3. #3

    Default

    Hi,
    Should i use the mysqlbinlog command to do the restore or does zmanda provides any utility for this.

    Sorry to ask these questions as i am a first time user and reading the doc as i type this.

    regards
    anandkl

  4. #4
    Join Date
    Oct 2006
    Posts
    199

    Default

    Quote Originally Posted by ananda View Post
    Hi,
    Should i use the mysqlbinlog command to do the restore or does zmanda provides any utility for this.

    Sorry to ask these questions as i am a first time user and reading the doc as i type this.

    regards
    anandkl
    you can use mysql-zrm --action restore

    --kkg

Posting Permissions

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