Partial backup - complete ibdata1


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 !


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.

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, /partial_backups.html?id=percona-xtrabackup:xtrabackup:parti al artial_backups_innobackupex.html


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 !