Recently I found the --tables-exclude option does not behavior as expected.
The backup command i used:
innobackupex --defaults-file=/usr/local/mysql-5.7.12/my.cnf --user=root --host=localhost --socket=/var/lib/mysql/mysql1.sock --password=root --no-timestamp --tables-exclude=test.t backup
There are three tables in database test,e.g. t,t2 and t3, i want to exclude table t from the backup, but i found innobackupex excludes all of the three tables.
Does --tables-exclude always treat the option value as regex that if the table in database test contains char ‘t’ and that table will be excluded?
innobackupex version:
innobackupex version 2.4.8 Linux (x86_64) (revision id: 97330f7)
MySQL version: 5.7.12
Feel free to response,thanks!