Backup one database with xtrabackup

MySQL & MariaDB Percona XtraBackup
1

Hello ;

On my cluster PXC, I have several databases. I want to backup only one of them. But the instruction I find out in the manual don’t show how to do it .

I juste find how to backup all the databases, or how to do an incremental backup. Does someone know some particular command?

Thanks in advance.

2

Percona Xtrabackup do supports Partial Backups. i.e. backup particular database/tables.
You need to use --include, --tables-file or --databases option to backup selected database/tables.

e.g.

$ mysql --skip-column-names -e “SELECT CONCAT(table_schema,‘.’,table_name) FROM information_schema.tables WHERE table_schema = ‘mydb’;” > tables.txt
$ innobackupex --tables-file=tables.txt /path/to/backupdir/

3

You can also use mysqldump command as like below mentioned for taken a single mysql database backup.

mysqldump -uabc -pabc dbname > dbname.sql

if you need single table then

mysqldump -uabc -pabc dbname tablenae > table.sql