Partial backup - complete ibdata1

[ghost974]

Hi,

I trying to backup some InnoDB databases, but I noticed that the backed-up ibdata1 is as large as the whole databases.

What am I doing wrong ?
MySQL 5.5

I used :

innobackupex --user=root --databases=“db1 db2 db3” /my/home/
innobackupex --apply-log /my/home/xtrabackup/

and then innobackupex --copy-back /my/home/xtrabackup/

Thanks !

[niljoshi]

Hi,

Is innodb_file_per_table enable on your server? It must be enabled for taking partial backup (selected dbs).

There is already open bug for --databases option as xtrabackup ignores it without --stream option.
[URL=“https://bugs.launchpad.net/percona-xtrabackup/+bug/569387”]https://bugs.launchpad.net/percona-xtrabackup/+bug/569387[/URL]

You can either use a regexp matching all the desired databases with --include option.
i.e innobackupex --include=‘^(aggiornamenti|corsi|corsi_storico|mysql|open). *’ …

You can get more information here,
http://www.percona.com/doc/percona-xtrabackup/xtrabackup_bin /partial_backups.html?id=percona-xtrabackup:xtrabackup:parti al

http://www.percona.com/doc/percona-xtrabackup/innobackupex/p artial_backups_innobackupex.html

[ghost974]

Hi,

I tried with --include instead of --databases, but the whole ibdata1 is still backed-up, whether there’s innodb tables or not.

So the only way to not get a complete ibdata1 is the innodb_file_per_table ?

Thanks !