It seems xtrabackup is not backing up binary logs, although it creates xtrabackup_binlog* with apparently correct information inside.
Should the binary logs be copied manually beforehand or is this a bug?
Mysql – thesql xtrabackup missing binary logs
backupMySQLxtrabackup
Related Question
- Mysql – xtrabackup prepare – after dump or before restore
- Mysql – Automatically purging binary logs
- MySQL binary log – write operation
- MySQL Still purging binary logs and ignoring expire_logs_days
- Mysql – xtrabackup doesn’t copy the binary log files (thesql-bin.xxxxx) shall i copy them manually? [solved]
- Mysql – a LSN (log sequence number)? How does xtrabackup Incremental Backup work
- Mysql – Percona Xtrabackup fails to backup InnoDB table with fulltext index
Best Answer
When using
xtrabackup
the binary logs aren't copied per file (but in one binlogfile). You need to restore this differently, see docs: Preparing a Full Backup with innobackupex.Or, with more extensive explanations:
In relation to your database not starting after restore, you might want to paste your
my.cnf
and server loghostname.err
.