innobackupex --include does not apply to the non-InnoDB tables

[Sheeri K. Cabral]

if you use --include to specify tables to include, it will work for filtering in/out innodb tables, but not for filtering in/out other table types (ie MyISAM).

[Sheeri K. Cabral (awfief)]

The fix, mostly stolen from earlier in the code:

*** innobackupex-1.5.1 2010-06-22 09:47:10.000000000 -0400
--- /usr/bin/innobackupex-1.5.1 2010-06-22 10:23:49.000000000 -0400
*************** sub backup_files {
*** 1916,1921 ****
--- 1916,1929 ----
              # mysql connection from timing out
              mysql_keep_alive();
              next unless check_if_required($database, $file);
+ if($option_include) {
+ if (!("$database.$file" =~ /$option_include/)) {
+ print STDERR "$database.$file is skipped because it does not match $option_include.\n";
+ next;
+ }
+ }
+
+
              if ($print_each_file) {
                  print STDERR "$prefix Backing up file '$source_dir/$database/$file'\n";
              }

[Will Bryant (willbryant)]

Use the --databases option.

[Vadim Tkachenko (vadim-tk)]

Fix commited, assigned to Valentine to provide test-case

[Valentine Gostev (longbow)]

I do not approve this fix. Skipped InnoDB tables are broken after restore. Please refer to bug https://bugs.launchpad.net/percona-xtrabackup/+bug/721339

[Valentine Gostev (longbow)]

Disregard my prev comment, please. That relates to docs.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-812