Comments on Perform Hot Backups of MySQL Databases with Percona XtraBackup on Ubuntu 16.04
Percona XtraBackup is an open source backup utility for MySQL. It supports all MySQL flavours like Percona Server, MariaDB, and (Oracle) MySQL. Percona Xtrabackup performs a Hot Backup for MySQL. In this tutorial, I will show you how to create a hot MySQL database backup with the OpenSource tool Percona XtraBackup on Ubuntu 16.04 (Xenial Xerus).
4 Comment(s)
Comments
Wow!
The weel was invented!
We should use xtrabackup instead of innobackupex for new implementations. As per percona documentation innobackupex is the symlink for xtrabackup. innobackupex still supports all features and syntax as 2.2 version did, but is now deprecated and will be removed in next major release.
Ermm how do I back up (and possibly restore?) just one database in /var/lib/mysql ?
For example /var/lib/mysql/foo
I mean we all like big data I'm sure but I'm keen to avoid unnecessary data bloat....
How do I make a backup of a specific database within a server where there are several databases?