Using mysqldump to implement MySQL 5.7 point-in-time recovery

Create test data

Fully-prepared database

mysqldump --single-transaction --flush-logs --master-data=2 --all-databases --triggers --routines --events --set-gtid-purged=off> backup.sql

Additional test data

Delete all data in a table

Confirm binary Log save file after last backup

Confirm the point in time at which data is deleted

Restoring a Database

Check the data in the table to indicate that the restore was successful

Recovering deleted data

mysqlbinlog --stop-datetime="2018-09-06 16:42:36" --skip-gtids mysql01-bin.000011 | mysql

Check the data in the table to indicate that it has been successfully restored

Using mysqldump to implement MySQL 5.7 point-in-time recovery