Results 1 to 2 of 2

Thread: Full Backup missing bin-logs?!

  1. #1
    Join Date
    Feb 2014
    Posts
    1

    Default Full Backup missing bin-logs?!

    Hi,

    I'm just evaluating ZRM (ZRM for MySQL Community Edition - version 3.0) for MySQL and doing FULL (via RAW / snapshot) and INCREMENTAL backups on a trial database. On a full database I seem to miss the bin-logs from the last incremental backup to the time the full backup is done.
    So if I'd want to restore to a time just before the full backup but after the last incremental backup I currently don't see the way to do so.

    backup_set backup_date backup_level backup_status backup_type comment
    -----------------------------------------------------------------------------------------------------------------------------
    sqtrial Sat Feb 15 10:15:56 2014 0 Backup succeeded regular SQTrial Backup (ZRM)
    sqtrial Sat Feb 15 10:03:31 2014 1 Backup succeeded regular SQTrial Backup (ZRM)
    sqtrial Sat Feb 15 10:03:24 2014 0 Backup succeeded regular SQTrial Backup (ZRM)
    sqtrial Sat Feb 15 10:03:14 2014 1 Backup succeeded regular SQTrial Backup (ZRM)

    bash-4.1$ find 2014021510* -name mysql\*
    20140215100314/mysql-bin.000871
    20140215100324/mysql
    20140215100331/mysql-bin.000874
    20140215101556/mysql

    -rw-rw---- 1 mysql mysql 167 Feb 15 10:03 mysql-bin.000871
    -rw-rw---- 1 mysql mysql 167 Feb 15 10:03 mysql-bin.000872
    -rw-rw---- 1 mysql mysql 167 Feb 15 10:03 mysql-bin.000873
    -rw-rw---- 1 mysql mysql 167 Feb 15 10:03 mysql-bin.000874
    -rw-rw---- 1 mysql mysql 167 Feb 15 10:15 mysql-bin.000875
    -rw-rw---- 1 mysql mysql 167 Feb 15 10:15 mysql-bin.000876
    -rw-rw---- 1 mysql mysql 120 Feb 15 10:15 mysql-bin.000877

    So the logs 872 and 873 are missing which would be required to restore to a certain point in time before the FULL backup.

    Any thoughts on this?!

    Thanks
    Sven

  2. #2
    Join Date
    Mar 2014
    Posts
    2

    Default

    Hello,
    On a full database I seem to miss the bin-logs from the last incremental backup to the time the full backup is done.

Posting Permissions

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