I tried full backup prepare
[root@mytestmachine]# 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
[root@mytestmachine]# 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 (root@linux) (gcc version 4.2.4)/x86_64
Kindly help me to figure out the problem
Thanks
raj