Chapter 15: Logical Backups
In this chapter, you will learn to create a backup of all data in the MySQL server, which will allow you to recover lost data, beginning with a comparative exploration of mysqldump and mysqlpump between logical and physical backups. You will make a backup copy of a single schema before learning to restore a database from a full backup or a schema from a single schema backup. We will use point-in-time restore to recover all data up to a specific point in time to minimize data loss during restoration. By the end of this chapter, you will be able to use the mysqlbinlog utility to inspect the contents of the binlog files.
This chapter covers the following concepts:
- An introduction to backups
- Understanding the basics of backups
- Logical and physical backup
- Types of restore
- Scheduling backups
- Using point-in-time recovery with
binlogfiles - Activity 15.01 – backing up and restoring a single schema
- Activity 15.02 –...
