Backup skips a DB - Bug?

MySQL & MariaDB Percona XtraBackup
1

Hi,

We use the innobackupex tool to backup a couple of databases:

/usr/bin/innobackupex --defaults-file=/etc/my.cnf --user=root --password=xxxx --tables-file /backup/tables /backup/MySQL

The tables file contains a list of tables such as:

adb-name.tbl1
adb-name.tbl2
adb-name.tbl3

Unfortunately all we get in the backup output is:

backup-my.cnf ibdata1 ibdata2 xtrabackup_binary xtrabackup_binlog_info xtrabackup_checkpoints xtrabackup_logfile

nothing for adb-name. We think this is down to the actual DB name, as MySQL stores it on disk as:

adb@002name

So whilst MySQL can deal with it, it doesn’t look like XtraBackup can.

For reasons that are out of our control, we can’t just dump the DB and restore it to a new name.

Thanks,

2

Karl,

Try listing on the tables file like this instead:

adb@002dname.tbl1
adb@002dname.tbl2
adb@002dname.tbl3

3

Hi,

Apologies for the delayed reply. Our testing shows that this makes no difference, we substitute the - for @002 and it still doesn’t do the backup.

Thanks,

Karl