PDA

View Full Version : Full Backup missing bin-logs?!



sopeters
February 14th, 2014, 03:13 PM
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

jamyjack
March 11th, 2014, 01:38 AM
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.