We are trying to make partial backups that allows more control in case of restore.
I’m using partial backup option and it seems like the option is ignored.
See the command:
innobackupex --databases=“mail” --no-timestamp /backup_dir/2012-09-12/
MySQL server configuration including the option innodb_file_per_table and the server is running with this option from the beginning.
The output of innobackupex indicates that all the other db’s are copied too.
Finally we get the backup directory full of other db’s backups.
Some server info:
mysqld Ver 5.1.63-0+squeeze1-log for debian-linux-gnu on x86_64 ((Debian))
Maybe we are missing something here.
Can you please try with below command and let me know it works or not?
innobackupex --include=“mail.” --no-timestamp /backup_dir/2012-09-12/
You can get more information here for partial backup.
Thanks for reply.
It actually worked but it I’ve noticed that other DB’s folders were created in backup directory without tables files in them. I’m curios why the option “–databases” doesn’t work as expected.
Another issue during preparation for restore - then I’m trying to perform the command:
“innobackupex --apply-log --export /backup/db_backup/full_backup/2012-09-19/”
it fails with the following error:
120919 09:59:31 innobackupex: Starting ibbackup with command: xtrabackup --defaults-file="/backup/db_backup/full_backup/2012-09-19/backup-my.cnf " --defaults-group=“mysqld” --prepare --target-dir=/backup/db_backup/full_backup/2012-09-19 --export
xtrabackup version 2.0.2 for Percona Server 5.1.59 unknown-linux-gnu (x86_64) (revision id: undefined)
xtrabackup: error: --export option can only be used with --innodb-file-per-table=ON.
innobackupex: ibbackup failed at /usr/bin/innobackupex line 374
I’m sure that the server is running with “innodb-file-per-table” option.
Any ideas? Have you seen this behavior before?