Comment 3 for bug 368945

Revision history for this message
Valentine Gostev (longbow) wrote :

root@dev302:~# xtrabackup --datadir=/var/lib/mysql --backup --target-dir=/root/backup/www
xtrabackup Ver 1.5 Rev 203 for 5.1.53 unknown-linux-gnu (x86_64)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
xtrabackup: Target instance is assumed 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
>> log scanned up to (224373)
[01] Copying ./ibdata1
     to /root/backup/www/ibdata1
[01] ...done
xtrabackup: The latest check point (for incremental): '224373'
>> log scanned up to (224373)
xtrabackup: Stopping log copying thread.
xtrabackup: Transaction log of lsn (224373) to (224373) was copied.
root@dev302:~# xtrabackup --prepare --target-dir=/root/backup/www
xtrabackup Ver 1.5 Rev 203 for 5.1.53 unknown-linux-gnu (x86_64)
xtrabackup: cd to /root/backup/www
xtrabackup: This target seems to be not prepared yet.
xtrabackup: xtrabackup_logfile detected: size=2097152, start_lsn=(224373)
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 = 1
xtrabackup: innodb_log_file_size = 2097152
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
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Compressed tables use zlib 1.2.3
InnoDB: Warning: innodb_file_io_threads is deprecated. Please use innodb_read_io_threads and innodb_write_io_threads instead
110217 23:46:06 InnoDB: highest supported file format is Barracuda.
110217 23:46:06 Percona XtraDB (http://www.percona.com) 1.0.13-12.4 started; log sequence number 224373

[notice (again)]
  If you use binary log and don't use any hack of group commit,
  the binary log position seems to be:

xtrabackup: starting shutdown with innodb_fast_shutdown = 1
110217 23:46:06 InnoDB: Starting shutdown...
110217 23:46:06 InnoDB: Shutdown completed; log sequence number 224373
root@dev302:~# echo $?
0
root@dev302:~# cat backup/www/xtrabackup_checkpoints
backup_type = full-prepared
from_lsn = 0
to_lsn = 224373
last_lsn = 224373

After that Percona Server was able to start with files restored from this backup