After setting up the database, the next important thing is to set up backups. In this chapter, you will learn how to set up various types of backups. There are two main ways to perform a backup. One is logical backup, which exports all the databases, table structures, data, and stored routines into a set of SQL statements that can be executed again to recreate the state of the database. The other type is physical backup, which contains all the files on the system that the databases used to store all the database entities:
- Logical backup utilities: mysqldump, mysqlpump, and mydumper (not shipped with MySQL)
- Physical backup utilities: XtraBackup (not shipped with MySQL) and flat file backup
For point-in-time recovery, the backup ...