Not recovery data (frm,MYI,MYD,etc..)

Asked by PandoraBox2007 on 2009-10-10

# xtrabackup --prepare --target-dir=/root/Pandora/sqltmp --datadir=/var/db/mysql
xtrabackup Ver undefined Rev undefined for 5.1.39 unknown-freebsd7.2 (x86_64)
xtrabackup: cd to /root/Pandora/sqltmp
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: Starting InnoDB instance for recovery.
xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
091010 22:07:54 InnoDB: Started; log sequence number 0 2802184716

[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
091010 22:07:54 InnoDB: Starting shutdown...
091010 22:07:56 InnoDB: Shutdown completed; log sequence number 0 2802184716

Question information

Language:
English Edit question
Status:
Solved
For:
Percona XtraBackup moved to https://jira.percona.com/projects/PXB Edit question
Assignee:
No assignee Edit question
Solved by:
PandoraBox2007
Solved:
2009-10-10
Last query:
2009-10-10
Last reply:

# uname -pisvr
FreeBSD 7.2-RELEASE FreeBSD 7.2-RELEASE #0: Fri May 1 07:18:07 UTC 2009 <email address hidden>:/usr/obj/usr/src/sys/GENERIC amd64 GENERIC

# ls -l /root/Pandora/sqltmp | du -mh /root/Pandora/sqltmp/*
5.0M /root/Pandora/sqltmp/ib_logfile0
5.0M /root/Pandora/sqltmp/ib_logfile1
146M /root/Pandora/sqltmp/ibdata1
2.0K /root/Pandora/sqltmp/xtrabackup_checkpoints
2.0M /root/Pandora/sqltmp/xtrabackup_logfile

target-dir ./xtrabackup_backupfiles/
backup FALSE
stats FALSE
prepare FALSE
export FALSE
print-param FALSE
use-memory 104857600
suspend-at-end FALSE
throttle 0
log-stream FALSE
incremental-lsn (No default value)
incremental-basedir (No default value)
incremental-dir (No default value)
tables (No default value)
create-ib-logfile FALSE
datadir ./
tmpdir (No default value)
innodb_adaptive_hash_index TRUE
innodb_additional_mem_pool_size 1048576
innodb_autoextend_increment 8
innodb_buffer_pool_size 8388608
innodb_checksums TRUE
innodb_data_file_path (No default value)
innodb_data_home_dir (No default value)
innodb_doublewrite TRUE
innodb_file_io_threads 4
innodb_file_per_table FALSE
innodb_flush_log_at_trx_commit 1
innodb_flush_method (No default value)
innodb_force_recovery 0
innodb_lock_wait_timeout 50
innodb_log_buffer_size 1048576
innodb_log_file_size 5242880
innodb_log_files_in_group 2
innodb_log_group_home_dir (No default value)
innodb_max_dirty_pages_pct 90
innodb_open_files 300