Summary

In this chapter, we learned why we need backups, what different options there are for creating backups, how to create backups, and how to restore them. We used mysqldump, mysqlpump, and mysqlbinlog in the process.

Using the tools provided by the OS, we practiced backup scheduling and performed full restores, partial restores, and point-in-time restores, in which we covered binlog files and GTIDs.

This helps us to keep our data safe and restore it when it is needed. It also taught us why we should test our backups. This gives us a valuable tool to copy data between servers by backing up and restoring it.

We have now covered all the fundamental concepts required to effectively use MySQL. Using the tools provided in this book, you should now have a strong foundation for working with MySQL as a database technology. Using this knowledge, you will be able to build and use a MySQL database for various purposes, such as application development and data analysis.

With this...