Not the answer you need?
Register and ask your own question!

Backup skips a DB - Bug?

Karl AustinKarl Austin EntrantCurrent User Role Beginner
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:

[email protected]

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,

Comments

  • revinrevin Contributor Current User Role Beginner
    Karl,

    Try listing on the tables file like this instead:

    [EMAIL="adb@002dname.tbl1"][email protected][/EMAIL]
    [EMAIL="adb@002dname.tbl2"][email protected][/EMAIL]
    [EMAIL="adb@002dname.tbl3"][email protected][/EMAIL]
  • Karl AustinKarl Austin Entrant Current User Role Beginner
    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
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.