Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I made a backup and according to Percona it completed successfully. Now I'm trying to prepare it and having the following issue:

./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.

I've been searching for answers for quite a while and not finding anything conclusive. Any advice on how to resolve this?


Edit: per comment below, here is requested info:

xtrabackup_55 version 2.0.3 for Percona Server 5.5.16 Linux (x86_64) (revision 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
share|improve this question
    
Can you provide the version of xtrabackup_55 that you're using (xtrabackup_55 --version), and any innodb configuration entries from your my.cnf file (or the output of show global variables like 'innodb%';)? –  Nathan Jolly May 23 '13 at 1:24
    
Percona xtrabackup documentation indicates that you should point xtrabackup_55 to the backup-my.cnf file taken with your backup, rather than your live my.cnf file. Though if you're doing the prep on the same server as the backup was taken, I'm not sure if it will make a difference. –  Nathan Jolly May 23 '13 at 1:28
    
Added, thanks... –  AJ. May 23 '13 at 1:28
    
Interesting, I switched it to use the backed up my.cnf file (in the backup dir), and now it's doing something :) Feel free to move that comment to an answer, sir. –  AJ. May 23 '13 at 1:30
add comment

1 Answer 1

up vote 2 down vote accepted

Percona xtrabackup documentation indicates that you should point xtrabackup_55 to the backup-my.cnf file taken with your backup, rather than your live my.cnf file.

If you're doing the prep on the same server as the backup was taken, I'm not sure if it will make a difference.

share|improve this answer
    
Thanks a lot Nathan! –  AJ. May 23 '13 at 1:34
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.