Not the answer you need?
Register and ask your own question!

error while prepare the incremental backups

karpagarajkarpagaraj EntrantCurrent User Role Beginner
I tried full backup prepare
============================
[[email protected]]# xtrabackup_51 --prepare --apply-log-only --target-dir=/root/backup/allbackup/1/2012-09-09_00-12-52
xtrabackup_51 version 2.0.2 for MySQL server 5.1.59 unknown-linux-gnu (x86_64) (revision id: 461)
xtrabackup: cd to /root/backup/allbackup/1/2012-09-09_00-12-52
xtrabackup: This target seems to be already prepared.
xtrabackup: notice: xtrabackup_logfile was already used to '--prepare'.
xtrabackup: Temporary instance for recovery is set as followings.
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 5242880
xtrabackup: Temporary instance for recovery is set as followings.
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 5242880
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
InnoDB: The InnoDB memory heap is disabled
120913 13:34:32 InnoDB: Initializing buffer pool, size = 100.0M
120913 13:34:32 InnoDB: Completed initialization of buffer pool

[notice (again)]
If you use binary log and don't use any hack of group commit,
the binary log position seems to be:
InnoDB: Last MySQL binlog file position 0 867857238, file name ./mysql-bin.002108

xtrabackup: starting shutdown with innodb_fast_shutdown = 1
120913 13:34:32 InnoDB: Starting shutdown...
120913 13:34:32 InnoDB: Shutdown completed; log sequence number 412 872729100
==================================
I facing the error while prepare the incremental backups
This is the error I facing here
[[email protected]]# xtrabackup_51 --prepare --apply-log-only --incremental-lsn='412 872729100' --target-dir=/root/backup/allbackup/1/2012-09-09_00-12-52/ --incremental-dir=/root/backup/allbackup/2/2012-09-10_00-06- 25/
xtrabackup: error: failed to read metadata from /root/backup/allbackup/2/2012-09-10_00-06-25//xtrabackup_che ckpoints

mysql and os details
====================
Mysql version details
======================
# mysqld_multi --version
mysqld_multi version 2.16 by Jani Tolonen
# mysql --version
mysql Ver 14.14 Distrib 5.5.23, for linux2.6 (x86_64) using readline 5.1

linux OS details
=================
Linux version 2.6.35.13-32 ([email protected]) (gcc version 4.2.4)/x86_64



Kindly help me to figure out the problem

Thanks
raj

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.