O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Introduction

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required