Howto backup only innodb files (no myisam stuff) with 2.3.2?

MySQL & MariaDB Percona XtraBackup
1

Hi,
incremental backups with xtrabackup 2.3.2 is somewhat useless for a database with 400GB of myisam tables and 50 GB of innodb tables, because in every incremental backup the 400 GB myisam stuff is copied again (now that xtrabackup includes myisam files and obsoletes innobackupex).

How can we revert the old behaviour and update innodb files only, completely ignoring all myisam tables?

Btw, to make incremental backup really usable with large myisam tables, it shouldn’t be too hard to use rsync on the myisam files together with “–link-dest=…/full/” to create a directory for the incremental backup that contains only the changed files and symlinks the others. The merge process could then just move the real files (that are not links) from the inc/ dir over the ones in the full/ dir.
Then an incremental backup would really be incremental for both, innodb and myisam tables.

cu,
Frank

2

Hi Frank;

You will likely just need to specify the InnoDB tables explicitly (partial backup). Not ideal, but I do not know of any other way to split it up unless you were to put all InnoDB tables into a separate database.

[url]Percona XtraBackup

-Scott

3

Thanks, Scott, I will try this! Maybe you could consider this as an option for the next release, sth. like “–innodb-only” to ignore all myisam stuff.
cu,
Frank