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
• Status: Not a Bug
• 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)
• CPU Architecture: Any
• Tags: Backup, include, innodb, list, Partial, tables

[21 Nov 2013 16:27] DB Support

Description:

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"