Duplicate
Details
Assignee
Rahul MalikRahul Malik(Deactivated)Reporter
Rahul MalikRahul Malik(Deactivated)Time tracking
2h loggedAffects versions
Priority
Medium
Details
Details
Assignee
Rahul Malik
Rahul Malik(Deactivated)Reporter
Rahul Malik
Rahul Malik(Deactivated)Time tracking
2h logged
Affects versions
Priority
Smart Checklist
Smart Checklist
Smart Checklist
Created May 21, 2021 at 1:57 PM
Updated March 6, 2024 at 6:40 PM
Resolved May 24, 2021 at 2:34 PM
my.cnf include the following information about:
[root@192 data]# cat /etc/my.cnf |grep 'log-bin|datadir'
datadir = /data/mysql
log-bin = /data/mysql/mybinlog
1.do backup
2.do prepare
prepare is ok , and I get the following values like :
[root@192 backup]# cat xtra_full_20210515160208/mybinlog.index
/data/mysql/mybinlog.000005
copy-back
xtrabackup --defaults-file=/etc/my.cnf --copy-back --target-dir=/data/backup/xtra_full_20210515160208/
When I finished executing --copy-back, I found that there was a problem,The index file of binlog is missing some information,When I change it to mybinlog.000005,MySQL can be started normally。
[root@192 ~]# cat /data/mysql/mybinlog.index
/data/mysql/.000005
https://forums.percona.com/t/is-this-a-bug-of-xtrabackup-8-0-23-16-and-mysql-8-0-23-when-i-executed-copy-back-there-was-an-error-in-the-index-file-of-binlog/10472