Mysql

Percona xtrabackup 準備失敗

  • May 23, 2013

我做了一個備份,根據 Percona 的說法,它成功完成了。現在我正在嘗試準備它並遇到以下問題:

./xtrabackup_55  --defaults-file="/etc/my.cnf"  --defaults-group="mysqld" --prepare --target-dir=/backup/unprepared/2013_05_21_21_31_41_full
xtrabackup: cd to /backup/unprepared/2013_05_21_21_31_41_full
xtrabackup: This target seems to be not prepared yet.
xtrabackup: No valid checkpoint found.
xtrabackup: Error: xtrabackup_init_temp_log() failed.

我一直在尋找答案很長一段時間,但沒有找到任何結論性的東西。關於如何解決這個問題的任何建議?


編輯:根據下面的評論,這裡是請求的資訊:

xtrabackup_55 版本 2.0.3,適用於 Percona Server 5.5.16 Linux (x86_64)(修訂版 ID:470)

cat /etc/my.cnf|grep innodb
innodb_data_home_dir = /data/mysql_data/
innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
innodb_log_group_home_dir = /var/mysql/data/
innodb_file_per_table
innodb_buffer_pool_size = 5G
innodb_additional_mem_pool_size = 40M
innodb_log_file_size = 1G
innodb_log_buffer_size = 16M
innodb_log_block_size = 512
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_thread_concurrency = 8
innodb_doublewrite_file = /var/mysql/innodb_doublewrite.buff
innodb_flush_method = ALL_O_DIRECT

Percona xtrabackup 文件表明您應該指向與備份一起獲取xtrabackup_55的文件,而不是您的實時 my.cnf 文件。backup-my.cnf

如果您在進行備份的同一台伺服器上進行準備,我不確定它是否會有所作為。

引用自:https://dba.stackexchange.com/questions/42855