Activity 15.02 – performing a point-in-time restore

In this activity, you will use the world schema to perform a point-in-time restore. The server you will use for this does not have GTIDs enabled. Follow the steps here to implement this activity:

1. Reset MASTER LOGS.
2. Create a backup with mysqldump.
3. Change the population of Toulouse in the city table.
4. Simulate the disaster by wiping out the complete city table.
5. Restore the backup.
6. Reapply the changes that occurred between backup creation and the time of the disaster.
7. Validate that the data has been restored.

After implementing these steps, the expected output is as follows:

Figure 15.8 – Inspecting the change that we made before

Note

The solution for this activity can be found in the Appendix.

Here, you can see that the special value we used has been restored correctly. Thus, in this activity, you created a backup, then made some additional changes, and...