Xtrabackup restore to point in time

MySQL & MariaDB Percona XtraBackup
1

Is there a way to restore to a specific point in time by specifying a date and time in xtrabackup?
example if I want to restore to 7am Feb 20 2025?
I have a weekly full backup and incremental daily backups.

Thanks

2

xtrabackup doesn’t copy binlogs. Please check if you still have binlogs on the original server. if you have binlogs on the original server, it is possible

Please check the documentation here: Point-in-time recovery - Percona XtraBackup

The key here is to:

  1. server shouldn’t purge binlogs that you need (or if you have saved binlogs, it is good)
  2. identify the binlog position recorded on Feb 20 2025 backup xtrabackup_binlog_info file.
  3. Generate the .SQL file from binlogs with your stop time
  4. execute the SQL file using MySQL client, on the server started from the prepared backup