Bug #70974 Mysqlbackup fails when including InnoDB tables for partial backup.
Submitted: 21 Nov 2013 16:27 Modified: 22 Nov 2013 13:00
Reporter: DB Support Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Enterprise Backup Severity:S1 (Critical)
Version:MySQL Enterprise Backup version 3.9.0 OS:Linux (Red Hat Enterprise Linux Server release 6.4)
Assigned to: CPU Architecture:Any
Tags: Backup, include, innodb, list, Partial, tables

[21 Nov 2013 16:27] DB Support

When performing a backup using mysqlbackup tool with option '--include=[LIST_OF_DB.TABLES_comma_separated]', it returns SUCCESS, but it does not really backup those list of InnoDB tables using "db.table" format.

We cannot use REGEXP as a value for backing up these tables because the tables belong to multiple databases.

How to repeat:

Execute mysqlbackup using --include option with the list of the db.tables as follows in the example:

mysqlbackup --host=$HOST --port=$PORT --protocol=tcp --user=$USER --password=$PASS --include=db1.table,db2.table,db3.table,database1,t1,database10.t --compress --compress-level=$LEVEL --skip-unused-pages --on-disk-full=abort_and_remove --backup-dir=$DIR_BACK/full --with-timestamp backup-to-image --backup-image=mysqldb.$DATE

Suggested fix:

Enable this option to swalow a list of InnoDB tables (comma separated) to be able to perform a partial backup.
[22 Nov 2013 13:00] Sveta Smirnova
Thank you for the report.

You use REGEXP in wrong way. You need to use it like:  --include="test.t1|test.t2"