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)

Add comment

Please register in our forum first to comment.

Comments

By: ferny

Wow!

The weel was invented!

By: lalit

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.

By: showe1966

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

By: Yoendrys A. Ugando Lavin

How do I make a backup of a specific database within a server where there are several databases?