MySQL Forums
Forum List  »  Backup

Restore incremental image failed (MEB 4.0.3)
Posted by: sys aim
Date: August 23, 2016 02:54AM

Hello,
i test the image incremental restore, but i have always an error about LSN.

What i do :

1) Backup image "full" :
mysqlbackup --backup-dir=/data/mysqldump --backup-image=full.bki backup-to-image

ok :
-------------------------------------------------------------
Parameters Summary
-------------------------------------------------------------
Start LSN : 86263200768
End LSN : 86497355612
-------------------------------------------------------------


2) Backup image "incrémental" :
mysqlbackup --incremental --incremental-base=history:last_backup --backup-image=/var/lib/mysqldump/incr_7am.mbi --backup-dir=/var/lib/mysqldump/tmp backup-to-image

ok :
-------------------------------------------------------------
Parameters Summary
-------------------------------------------------------------
Start LSN : 86497355613
End LSN : 86519012050
-------------------------------------------------------------

3) Stop MySQL and remove files from datadir
systemctl stop mysqld
rm -rf /var/lib/mysql/


4) Restore Backup Full :

mysqlbackup --datadir=/var/lib/mysql --backup-image=/var/lib/mysqldump/full.bki --backup-dir=/var/lib/mysqldump copy-back-and-apply-log


ok :
160822 15:17:37 mysqlbackup: INFO: We were able to parse ibbackup_logfile up to
lsn 86497355612.
160822 15:17:37 mysqlbackup: INFO: The first data file is '/var/lib/mysql/ibdata1'
and the new created log files are at '/var/lib/mysql'
mysqlbackup: INFO: MySQL server version is '5.7.12'
mysqlbackup: INFO: Restoring ...5.7.12 version
160822 15:17:37 mysqlbackup: INFO: Apply-log operation completed successfully.
160822 15:17:37 mysqlbackup: INFO: Full Backup has been restored successfully.

mysqlbackup completed OK! with 2 warnings


5) Restore Backup incremental :
mysqlbackup --datadir=/var/lib/mysql --backup-image=/var/lib/mysqldump/incr_7am.mbi --backup_dir=/var/lib/mysqldump/ --incremental copy-back-and-apply-log


==> ERROR :
160822 15:18:49 mysqlbackup: INFO: ibbackup_logfile's creation parameters:
start lsn 86263200768, end lsn 86497355612,
start checkpoint 86263200945.
mysqlbackup: INFO: InnoDB: Doing recovery: scanned up to log sequence number 86263200768.
mysqlbackup: INFO: InnoDB: Starting an apply batch of log records to the database...
.
InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
mysqlbackup: INFO: InnoDB: Setting log file size to 2147483648.
mysqlbackup: INFO: InnoDB: Progress in MB:.
100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000
mysqlbackup: INFO: InnoDB: Setting log file size to 2147483648.
mysqlbackup: INFO: InnoDB: Progress in MB:.
100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000
mysqlbackup: ERROR: We were only able to scan ibbackup_logfile up to
lsn 86263200768, but the log file end is at lsn 86497355612!
The backup prepared for recovery may be corrupt!


Thank you for your help
Thierry

Options: ReplyQuote


Subject
Views
Written By
Posted
Restore incremental image failed (MEB 4.0.3)
1832
August 23, 2016 02:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.