Results 1 to 4 of 4

Thread: ZRM Incremental+Full Backup

  1. #1

    Default ZRM Incremental+Full Backup

    Hi,

    I just heard of ZRM for MySQL and figured I'd ask a few questions here.
    My goal is to do hourly incremental backups of my MySQL databases.
    After the last hourly backup I would like to take one big snapshot of all the databases for the entire day... So I want to do incremental and full backups everyday for my MySQL database is ZRM for MySQL able to do this and if so is it reliable?

  2. #2
    Join Date
    Oct 2005
    Posts
    1,559

    Default

    Quote Originally Posted by pr0t View Post
    Hi,

    I just heard of ZRM for MySQL and figured I'd ask a few questions here.
    My goal is to do hourly incremental backups of my MySQL databases.
    After the last hourly backup I would like to take one big snapshot of all the databases for the entire day... So I want to do incremental and full backups everyday for my MySQL database is ZRM for MySQL able to do this and if so is it reliable?
    ZRM for MySQL does full and incremental backups reliably. Many people are using it in production in various configurations. We (Zmanda) also use it to backup our infrastructure.

    Doing daily full backup is straightforward. Currently, ZRM for MySQL supports monthly, weekly, daily scheduling. So, doing hourly backup will require some modifications. Since ZRM for MySQL uses cron jobs to actual execute the backup, you can change the crontab entry for hourly backups.

    If you have questions, please post them here.

    Paddy

  3. #3

    Default Incremental backups

    Okay, sounds great... so with ZRM I can do hourly incremental backups for changes that occurred on a database within that hour and then at the end of the day I can schedule another cronjob to do a full backup correct? how much tweaking or configuration of ZRM would this take to achieve?

  4. #4
    Join Date
    Oct 2005
    Posts
    1,559

    Default

    Quote Originally Posted by pr0t View Post
    Okay, sounds great... so with ZRM I can do hourly incremental backups for changes that occurred on a database within that hour and then at the end of the day I can schedule another cronjob to do a full backup correct? how much tweaking or configuration of ZRM would this take to achieve?
    Daily full backups you don't have to do any tweaking. See the manual section on scheduling - [url]http://mysqlbackup.zmanda.com/index.php/Daily/_Weekly/_Monthly_Schedules[/url]

    For Hourly incremental backups, you will have schedule it as daily backup and change the crontab entry.

    Paddy

Posting Permissions

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