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