Mastering MySQL Administration: High Availability, Security, Performance, and Efficiency

© Y V Ravi Kumar, Arun Kumar Samayam, Naresh Kumar Miryala 2024

Y. V. Ravi Kumar et al.Mastering MySQL Administrationhttps://doi.org/10.1007/979-8-8688-0252-2_8

8. MySQL Logical Backup

Y V Ravi Kumar¹  , Arun Kumar Samayam² and Naresh Kumar Miryala³

(1)

Irving, TX, USA

(2)

Dallas, TX, USA

(3)

Tracy, CA, USA

 

Introduction

In most enterprises using open source versions of MySQL, MySQL Enterprise Backup might not be an option to perform backup and restore operations. In such cases, we have a few logical backup options that we showcase here in this chapter. In addition, there are several third-party licensed backup softwares in the market that can help meet your backup and restore needs:

• mysqldump

• mydumper and myloader

• Percona XtraBackup

Using mysqldump

This is ...