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 ...
Get The MySQL Workshop now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
