How to Create Partial Backups Using MySQL Enterprise Backup

Few usage examples.
We have following setup for our tests:

Tables t1, t2, d1, d2 in all databases use InnoDB storage engine and tables t11, t12, d11, d12 use MyISAM storage engine.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| db1                |
| db2                |
| mtr                |
| mysql              |
| performance_schema |
| test               |
+--------------------+
7 rows in set (0.00 sec)

mysql> show tables from db1;
+---------------+
| Tables_in_db1 |
+---------------+
| d1            |
| d11           |
| d12           |
| d2            |
| t1            |
| t11           |
| t12           |
| t2            |
+---------------+
8 rows in set (0.00 sec)

mysql> show tables from db2;
+---------------+
| Tables_in_db2 |
+---------------+
| d1            |
| d11           |
| d12           |
| d2            |
| t1            |
| t11           |
| t12           |
| t2            |
+---------------+
8 rows in set (0.00 sec)

mysql> show tables from test;
+----------------+
| Tables_in_test |
+----------------+
| t1             |
| t11            |
+----------------+
2 rows in set (0.00 sec)

Example 1.

[sveta@delly meb-trunk]$ ./bin/mysqlbackup --user=root --socket=/home/sveta/build/mysql-5.5/mysql-test/var/tmp/mysqld.1.sock --backup-dir=/home/sveta/src/BACKUPDIR/KM1 --include="(db1|db2).*" backup
MySQL Enterprise Backup version 3.8.0 [2012/03/22] 
Copyright (c) 2003, 2012, Oracle and/or its affiliates. All Rights Reserved.

<skipped>

120331 0:24:41 mysqlbackup: INFO: Copying log...
120331 0:24:41 mysqlbackup: INFO: Log copied, lsn 1669595.
We wait 1 second before starting copying the data files...
120331 0:24:42 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/ibdata1 (Antelope file format).
120331 0:24:43 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db1/t2.ibd (Antelope file format).
120331 0:24:43 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db1/d1.ibd (Antelope file format).
120331 0:24:43 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db1/t1.ibd (Antelope file format).
120331 0:24:43 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db1/d2.ibd (Antelope file format).
120331 0:24:43 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db2/t2.ibd (Antelope file format).
120331 0:24:43 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db2/d1.ibd (Antelope file format).
120331 0:24:43 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db2/t1.ibd (Antelope file format).
120331 0:24:43 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db2/d2.ibd (Antelope file format).
mysqlbackup: INFO: Preparing to lock tables: Connected to mysqld server.
120331 00:24:43 mysqlbackup: INFO: Starting to lock all the tables....
120331 00:24:44 mysqlbackup: INFO: All tables are locked and flushed to disk
mysqlbackup: INFO: Opening backup source directory '/home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/'
120331 00:24:44 mysqlbackup: INFO: Starting to backup all files in subdirectories of '/home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/'
mysqlbackup: INFO: Backing up the database directory 'db1'
mysqlbackup: INFO: Backing up the database directory 'db2'
mysqlbackup: INFO: Backing up the database directory 'mtr'
mysqlbackup: INFO: Backing up the database directory 'mysql'
mysqlbackup: INFO: Backing up the database directory 'performance_schema'
mysqlbackup: INFO: Backing up the database directory 'test'
mysqlbackup: INFO: Copying innodb data and logs during final stage ...

<skipped>

mysqlbackup completed OK!
[sveta@delly meb-trunk]$ ls /home/sveta/src/BACKUPDIR/KM1/datadir/
db1 db2 ibbackup_logfile ibdata1 mtr mysql performance_schema test
[sveta@delly meb-trunk]$ ls /home/sveta/src/BACKUPDIR/KM1/datadir/db1
d11.frm d11.MYI d12.MYD d1.frm d2.frm db.opt t11.MYD t12.frm t12.MYI t1.ibd t2.ibd
d11.MYD d12.frm d12.MYI d1.ibd d2.ibd t11.frm t11.MYI t12.MYD t1.frm t2.frm
[sveta@delly meb-trunk]$ ls /home/sveta/src/BACKUPDIR/KM1/datadir/db2
d11.frm d11.MYI d12.MYD d1.frm d2.frm db.opt t11.MYD t12.frm t12.MYI t1.ibd t2.ibd
d11.MYD d12.frm d12.MYI d1.ibd d2.ibd t11.frm t11.MYI t12.MYD t1.frm t2.frm
[sveta@delly meb-trunk]$ ls /home/sveta/src/BACKUPDIR/KM1/datadir/test/
t11.frm t11.MYD t11.MYI t1.frm

As you see all InnoDB tables from databases db1 and db2 were copied and no InnoDB table from test database was copied, although *.frm file is still there. This happened, because we specified option --include="(db1|db2).*" which filters InnoDB data files and have not specified option --databases. Therefore only those InnoDB data files those names satisfy expression specified, InnoDB log files and shared tablespace should be copied together with non-InnoDB and all *frm files.


Example 2.

[sveta@delly meb-trunk]$ ./bin/mysqlbackup --user=root --socket=/home/sveta/build/mysql-5.5/mysql-test/var/tmp/mysqld.1.sock --backup-dir=/home/sveta/src/BACKUPDIR/KM2 --include="db1.t.*" backup
MySQL Enterprise Backup version 3.8.0 [2012/03/22] 
Copyright (c) 2003, 2012, Oracle and/or its affiliates. All Rights Reserved.

<skipped>

120331 0:30:35 mysqlbackup: INFO: Copying log...
120331 0:30:35 mysqlbackup: INFO: Log copied, lsn 1700565.
We wait 1 second before starting copying the data files...
120331 0:30:36 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/ibdata1 (Antelope file format).
120331 0:30:37 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db1/t2.ibd (Antelope file format).
120331 0:30:37 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db1/t1.ibd (Antelope file format).
mysqlbackup: INFO: Preparing to lock tables: Connected to mysqld server.

<skipped>

mysqlbackup completed OK!
[sveta@delly meb-trunk]$ ls /home/sveta/src/BACKUPDIR/KM2/datadir/
db1 db2 ibbackup_logfile ibdata1 mtr mysql performance_schema test
[sveta@delly meb-trunk]$ ls /home/sveta/src/BACKUPDIR/KM2/datadir/db1
d11.frm d11.MYD d11.MYI d12.frm d12.MYD d12.MYI d1.frm d2.frm db.opt t11.frm t11.MYD t11.MYI t12.frm t12.MYD t12.MYI t1.frm t1.ibd t2.frm t2.ibd
[sveta@delly meb-trunk]$ ls /home/sveta/src/BACKUPDIR/KM2/datadir/db2
d11.frm d11.MYD d11.MYI d12.frm d12.MYD d12.MYI d1.frm d2.frm db.opt t11.frm t11.MYD t11.MYI t12.frm t12.MYD t12.MYI t1.frm t2.frm
[sveta@delly meb-trunk]$ ls /home/sveta/src/BACKUPDIR/KM2/datadir/test/
t11.frm t11.MYD t11.MYI t1.frm

In this case we used different regular expression, therefore data files of InnoDB tables those names started with "t" and which belong to database db1 were copied while InnoDB tables belonging to other databases were not copied.


Example 3.


Now lets try out option --databases.

[sveta@delly meb-trunk]$ ./bin/mysqlbackup --user=root --socket=/home/sveta/build/mysql-5.5/mysql-test/var/tmp/mysqld.1.sock --backup-dir=/home/sveta/src/BACKUPDIR/KM3 --databases=db1 backup
MySQL Enterprise Backup version 3.8.0 [2012/03/22] 
Copyright (c) 2003, 2012, Oracle and/or its affiliates. All Rights Reserved.

<skipped>

120331 0:32:42 mysqlbackup: INFO: Copying log...
120331 0:32:42 mysqlbackup: INFO: Log copied, lsn 1707403.
We wait 1 second before starting copying the data files...
120331 0:32:43 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/ibdata1 (Antelope file format).
120331 0:32:43 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/test/t1.ibd (Antelope file format).
120331 0:32:43 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db1/t2.ibd (Antelope file format).
120331 0:32:43 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db1/d1.ibd (Antelope file format).
120331 0:32:43 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db1/t1.ibd (Antelope file format).
120331 0:32:43 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db1/d2.ibd (Antelope file format).
120331 0:32:43 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db2/t2.ibd (Antelope file format).
120331 0:32:43 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db2/d1.ibd (Antelope file format).
120331 0:32:44 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db2/t1.ibd (Antelope file format).
120331 0:32:44 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db2/d2.ibd (Antelope file format).
mysqlbackup: INFO: Preparing to lock tables: Connected to mysqld server.
120331 00:32:44 mysqlbackup: INFO: Starting to lock all the tables....
120331 00:32:44 mysqlbackup: INFO: All tables are locked and flushed to disk
mysqlbackup: INFO: Opening backup source directory '/home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/'
120331 00:32:44 mysqlbackup: INFO: Starting to backup all files in subdirectories of '/home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/'
mysqlbackup: INFO: Backing up the database directory 'db1'
mysqlbackup: INFO: Copying innodb data and logs during final stage ...

<skipped>

mysqlbackup completed OK!
[sveta@delly meb-trunk]$ ls /home/sveta/src/BACKUPDIR/KM3/datadir/
db1 db2 ibbackup_logfile ibdata1 test
[sveta@delly meb-trunk]$ ls /home/sveta/src/BACKUPDIR/KM3/datadir/db1
d11.frm d11.MYI d12.MYD d1.frm d2.frm db.opt t11.MYD t12.frm t12.MYI t1.ibd t2.ibd
d11.MYD d12.frm d12.MYI d1.ibd d2.ibd t11.frm t11.MYI t12.MYD t1.frm t2.frm
[sveta@delly meb-trunk]$ ls /home/sveta/src/BACKUPDIR/KM3/datadir/db2
d1.ibd d2.ibd t1.ibd t2.ibd
[sveta@delly meb-trunk]$ ls /home/sveta/src/BACKUPDIR/KM3/datadir/test/
t1.ibd

As you can see all table files in database db1 were copied, but only InnoDB data files from others were copied.


Example 4.


Another example of how filtering of non-InnoDB tables:

[sveta@delly meb-trunk]$ ./bin/mysqlbackup --user=root --socket=/home/sveta/build/mysql-5.5/mysql-test/var/tmp/mysqld.1.sock --backup-dir=/home/sveta/src/BACKUPDIR/KM4 --databases="db1 db2.t11" backup
MySQL Enterprise Backup version 3.8.0 [2012/03/22] 
Copyright (c) 2003, 2012, Oracle and/or its affiliates. All Rights Reserved.

<skipped>

120331 0:36:18 mysqlbackup: INFO: Copying log...
120331 0:36:18 mysqlbackup: INFO: Log copied, lsn 1727933.
We wait 1 second before starting copying the data files...
120331 0:36:19 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/ibdata1 (Antelope file format).
120331 0:36:19 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/test/t1.ibd (Antelope file format).
120331 0:36:20 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db1/t2.ibd (Antelope file format).
120331 0:36:20 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db1/d1.ibd (Antelope file format).
120331 0:36:20 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db1/t1.ibd (Antelope file format).
120331 0:36:20 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db1/d2.ibd (Antelope file format).
120331 0:36:20 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db2/t2.ibd (Antelope file format).
120331 0:36:20 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db2/d1.ibd (Antelope file format).
120331 0:36:20 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db2/t1.ibd (Antelope file format).
120331 0:36:20 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db2/d2.ibd (Antelope file format).
mysqlbackup: INFO: Preparing to lock tables: Connected to mysqld server.
120331 00:36:20 mysqlbackup: INFO: Starting to lock all the tables....
120331 00:36:20 mysqlbackup: INFO: All tables are locked and flushed to disk
mysqlbackup: INFO: Opening backup source directory '/home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/'
120331 00:36:20 mysqlbackup: INFO: Starting to backup all files in subdirectories of '/home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/'
mysqlbackup: INFO: Backing up the database directory 'db1'
mysqlbackup: INFO: Backing up the database directory 'db2'
mysqlbackup: INFO: Copying innodb data and logs during final stage ...

<skipped>

mysqlbackup completed OK!
[sveta@delly meb-trunk]$ ls /home/sveta/src/BACKUPDIR/KM4/datadir/
db1 db2 ibbackup_logfile ibdata1 test
[sveta@delly meb-trunk]$ ls /home/sveta/src/BACKUPDIR/KM4/datadir/db1
d11.frm d11.MYI d12.MYD d1.frm d2.frm db.opt t11.MYD t12.frm t12.MYI t1.ibd t2.ibd
d11.MYD d12.frm d12.MYI d1.ibd d2.ibd t11.frm t11.MYI t12.MYD t1.frm t2.frm
[sveta@delly meb-trunk]$ ls /home/sveta/src/BACKUPDIR/KM4/datadir/db2
d1.ibd d2.ibd t11.frm t11.MYD t11.MYI t1.ibd t2.ibd
[sveta@delly meb-trunk]$ ls /home/sveta/src/BACKUPDIR/KM4/datadir/test/
t1.ibd

We have all tables in db1 database, all InnoDB tables and MyISAM table t11 in db2 and only InnoDB table in database test.


Options --include and --databases provide very powerful way to do backups even if called alone, but you can want more. Say, don't want to backup all MyISAM files when do InnoDB backup, or only part of them. This can be achived by combining of two options.


Example 5.


Backup of only InnoDB data files in databases db1 and db2:

[sveta@delly meb-trunk]$ ./bin/mysqlbackup --user=root --socket=/home/sveta/build/mysql-5.5/mysql-test/var/tmp/mysqld.1.sock --backup-dir=/home/sveta/src/BACKUPDIR/KM5 --include="(db1|db2).*" --databases=not_existant backup
MySQL Enterprise Backup version 3.8.0 [2012/03/22] 
Copyright (c) 2003, 2012, Oracle and/or its affiliates. All Rights Reserved.

<skipped>

120331 0:43:27 mysqlbackup: INFO: Copying log...
120331 0:43:27 mysqlbackup: INFO: Log copied, lsn 1734895.
We wait 1 second before starting copying the data files...
120331 0:43:28 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/ibdata1 (Antelope file format).
120331 0:43:28 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db1/t2.ibd (Antelope file format).
120331 0:43:28 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db1/d1.ibd (Antelope file format).
120331 0:43:28 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db1/t1.ibd (Antelope file format).
120331 0:43:28 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db1/d2.ibd (Antelope file format).
120331 0:43:28 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db2/t2.ibd (Antelope file format).
120331 0:43:28 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db2/d1.ibd (Antelope file format).
120331 0:43:28 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db2/t1.ibd (Antelope file format).
120331 0:43:28 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db2/d2.ibd (Antelope file format).
mysqlbackup: INFO: Preparing to lock tables: Connected to mysqld server.
120331 00:43:29 mysqlbackup: INFO: Starting to lock all the tables....
120331 00:43:29 mysqlbackup: INFO: All tables are locked and flushed to disk
mysqlbackup: INFO: Opening backup source directory '/home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/'
120331 00:43:29 mysqlbackup: INFO: Starting to backup all files in subdirectories of '/home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/'
mysqlbackup: INFO: Copying innodb data and logs during final stage ...

<skipped>

mysqlbackup completed OK!
[sveta@delly meb-trunk]$ ls /home/sveta/src/BACKUPDIR/KM5/datadir/
db1 db2 ibbackup_logfile ibdata1
[sveta@delly meb-trunk]$ ls /home/sveta/src/BACKUPDIR/KM5/datadir/db1
d1.ibd d2.ibd t1.ibd t2.ibd
[sveta@delly meb-trunk]$ ls /home/sveta/src/BACKUPDIR/KM5/datadir/db2
d1.ibd d2.ibd t1.ibd t2.ibd

In this case only InnoDB data files were copied. To achive this we pointed option --databases to not existent database "not_existant", so only InnoDB data files specified in option --include were copied.


Example 6.


How to make partial copy of InnoDB tables with their *frm files, but skip all non-InnoDB tables:

[sveta@delly meb-trunk]$ ./bin/mysqlbackup --user=root --socket=/home/sveta/build/mysql-5.5/mysql-test/var/tmp/mysqld.1.sock --backup-dir=/home/sveta/src/BACKUPDIR/KM6 --include="(db1|db2).*" --databases="db1.t1 db1.t2 db2.t1 db2.t2" backup
MySQL Enterprise Backup version 3.8.0 [2012/03/22] 
Copyright (c) 2003, 2012, Oracle and/or its affiliates. All Rights Reserved.

<skipped>

120331 0:45:27 mysqlbackup: INFO: Copying log...
120331 0:45:27 mysqlbackup: INFO: Log copied, lsn 1748803.
We wait 1 second before starting copying the data files...
120331 0:45:28 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/ibdata1 (Antelope file format).
120331 0:45:28 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db1/t2.ibd (Antelope file format).
120331 0:45:28 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db1/d1.ibd (Antelope file format).
120331 0:45:28 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db1/t1.ibd (Antelope file format).
120331 0:45:29 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db1/d2.ibd (Antelope file format).
120331 0:45:29 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db2/t2.ibd (Antelope file format).
120331 0:45:29 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db2/d1.ibd (Antelope file format).
120331 0:45:29 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db2/t1.ibd (Antelope file format).
120331 0:45:29 mysqlbackup: INFO: Copying /home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/db2/d2.ibd (Antelope file format).
mysqlbackup: INFO: Preparing to lock tables: Connected to mysqld server.
120331 00:45:29 mysqlbackup: INFO: Starting to lock all the tables....
120331 00:45:29 mysqlbackup: INFO: All tables are locked and flushed to disk
mysqlbackup: INFO: Opening backup source directory '/home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/'
120331 00:45:29 mysqlbackup: INFO: Starting to backup all files in subdirectories of '/home/sveta/build/mysql-5.5/mysql-test/var/mysqld.1/data/'
mysqlbackup: INFO: Backing up the database directory 'db1'
mysqlbackup: INFO: Backing up the database directory 'db2'
mysqlbackup: INFO: Copying innodb data and logs during final stage ...

<skipped>

mysqlbackup completed OK!
[sveta@delly meb-trunk]$ ls /home/sveta/src/BACKUPDIR/KM6/datadir/
db1 db2 ibbackup_logfile ibdata1
[sveta@delly meb-trunk]$ ls /home/sveta/src/BACKUPDIR/KM6/datadir/db1
d1.ibd d2.ibd t1.frm t1.ibd t2.frm t2.ibd
[sveta@delly meb-trunk]$ ls /home/sveta/src/BACKUPDIR/KM6/datadir/db2
d1.ibd d2.ibd t1.frm t1.ibd t2.frm t2.ibd

Here options --include="(db1|db2).*" and --databases="db1.t1 db1.t2 db2.t1 db2.t2" point to the same set of tables which should be copied.