Reopened Issue with weird situation:
When Table is create in '/var/lib/mysql_tablespaces':
mysql> CREATE TABLE `t2` ( -> `c1` int(11) NOT NULL, -> PRIMARY KEY (`c1`) -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1 DATA DIRECTORY='/var/lib/mysql_tablespaces'; Query OK, 0 rows affected (0.02 sec)
mysql> set tokudb_backup_dir='/home/tokubackupdir'; Query OK, 0 rows affected (2.57 sec)
The backup will copy t2.ibd:
root@percona-XPS-15:/home/tokubackupdir# ls mysql_data_dir_tablespaces/t1/ t1.ibd t2.ibd
But if you create table as:
CREATE TABLE `t2` ( `c1` int(11) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 DATA DIRECTORY='/home/datadir/'
Backup will missed t2.ibd.
Reopened Issue with weird situation:
When Table is create in '/var/lib/ mysql_tablespac es':
mysql> CREATE TABLE `t2` ( '/var/lib/ mysql_tablespac es';
-> `c1` int(11) NOT NULL,
-> PRIMARY KEY (`c1`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=latin1 DATA DIRECTORY=
Query OK, 0 rows affected (0.02 sec)
mysql> set tokudb_ backup_ dir='/home/ tokubackupdir' ;
Query OK, 0 rows affected (2.57 sec)
The backup will copy t2.ibd:
root@percona- XPS-15: /home/tokubacku pdir# ls mysql_data_ dir_tablespaces /t1/
t1.ibd t2.ibd
But if you create table as:
CREATE TABLE `t2` ( '/home/ datadir/ '
`c1` int(11) NOT NULL,
PRIMARY KEY (`c1`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 DATA DIRECTORY=
Backup will missed t2.ibd.