# xtrabackup: Error: cannot open ./xtrabackup\_checkpoints

**URL:** <https://forums.percona.com/t/xtrabackup-error-cannot-open-xtrabackup-checkpoints/5331>\
**Category:** Percona XtraBackup\
**Created:** [January 3, 2017, 12:10pm UTC](https://forums.percona.com/t/xtrabackup-error-cannot-open-xtrabackup-checkpoints/5331 "2017-01-03T12:10:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![silaphet](https://avatars.discourse-cdn.com/v4/letter/s/9fc29f/32.png) [@silaphet](https://forums.percona.com/u/silaphet)\
**Post date:** [January 3, 2017, 12:10pm UTC](https://forums.percona.com/t/xtrabackup-error-cannot-open-xtrabackup-checkpoints/5331/1 "2017-01-03T12:10:04Z")

</div>

Hi Forums,

I’'m trying to setup the master-slave replication by using xtrabackup method. However, when trying to run hot backups and Percona is complaining missing something. Here is complete output.

​​​​​​innobackupex --apply-log /apps/perconabackup/

161220 14:26:27 innobackupex: Starting the apply-log operation

IMPORTANT: Please check that the apply-log run completes successfully.

At the end of a successful apply-log run innobackupex

prints “completed OK!”.

innobackupex version 2.4.5 based on MySQL server 5.7.13 Linux (x86\_64) (revision id: e41c0be)

xtrabackup: cd to /apps/perconabackup/

xtrabackup: Error: cannot open ./xtrabackup\_checkpoints

xtrabackup: Error: failed to read metadata from ‘./xtrabackup\_checkpoints’

here is environment setup:  
RHEL 7.0

xtrabackup --version  
xtrabackup version 2.4.5 based on MySQL server 5.7.13 Linux (x86\_64) (revision id: e41c0be)

​​​​​​mysql -V  
mysql Ver 14.14 Distrib 5.7.14-8, for Linux (x86\_64) using 6.2

Here are my.cnf options file on the master.

cat /etc/my.cnf

# Template my.cnf for PXC

# Edit to your requirements.

[client]

socket=/var/lib/mysql/mysql.sock

[mysqld]

server-id=1

datadir=/apps/mysql/datafile

socket=/var/lib/mysql/mysql.sock

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

log\_slave\_updates

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

# Path to Galera library

wsrep\_provider=/usr/lib64/galera3/libgalera\_smm.so

# Cluster connection URL contains IPs of nodes

#If no IP is found, this implies that a new cluster needs to be created,

#in order to do that you need to bootstrap this node

wsrep\_cluster\_address=gcomm://

###InnoDB

default\_storage\_engine=InnoDB

innodb\_log\_file\_size=128M

innodb\_flush\_method = O\_DIRECT

innodb\_file\_per\_table=1

innodb\_data\_home\_dir=/apps/mysql/datafile/

innodb\_log\_group\_home\_dir =/apps/mysql/datafile/

## Replication and binlogs

binlog\_format=ROW

binlog\_cache\_size = 1M

max\_binlog\_files=300

max\_binlog\_size=128M

log\_bin=/apps/mysql/logfile/percona1-binary-log

expire\_logs\_days=3

What is exactly am I missing here?

Your help or instruction is really appreciated.

Thanks,  
Silaphet

---

<div class="post-metadata">

**Author:** ![yunus\_shaikh](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/yunus_shaikh/32/3512_2.png) [@yunus\_shaikh](https://forums.percona.com/u/yunus_shaikh)\
**Post date:** [February 2, 2023, 3:11pm UTC](https://forums.percona.com/t/xtrabackup-error-cannot-open-xtrabackup-checkpoints/5331/3 "2023-02-02T15:11:59Z")

</div>

Did your backup finish successfully?  
Can you make sure you have successfull backup?  
This can occur if there was a backup which did not complete properly.