Activity 15.01 – backing up and restoring a single schema

In this activity, you will create a simulated disaster in the world schema and recover from this disaster. For this, you will be using mysqldump. Perform the following steps to complete this activity:

1. Create the backup of the world schema.
2. Simulate the disaster. Here, delete all the rows of the city table.
3. Restore the backup.
4. Verify that the data has been restored.

The expected output is as follows:

Figure 15.7 – The total rows in the city table after restoring

Note

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

Here, we successfully restored the world schema after wiping out the city table. As there were no other changes made to the world schema between the time of the backup and the time of DELETE, we have restored all the data.

In the next activity, we will perform a point-in-time restore.