# \[SOLVED\] Partial Backup: database selection issues

**URL:** <https://forums.percona.com/t/solved-partial-backup-database-selection-issues/2301>\
**Category:** Percona XtraBackup\
**Created:** [October 11, 2012, 12:28am UTC](https://forums.percona.com/t/solved-partial-backup-database-selection-issues/2301 "2012-10-11T00:28:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mlnzigzag](https://avatars.discourse-cdn.com/v4/letter/m/7993a0/32.png) [@mlnzigzag](https://forums.percona.com/u/mlnzigzag)\
**Post date:** [October 11, 2012, 12:28am UTC](https://forums.percona.com/t/solved-partial-backup-database-selection-issues/2301/1 "2012-10-11T00:28:37Z")

</div>

Hello,

innobackupex --databases=‘aggiornamenti corsi corsi\_storico mysql openx’ provabck/

This command will backup the whole mysql server!  
Including databases with names like “medico” “mediconew” etc.

innobackupex --include=‘aggiornamenti corsi corsi\_storico mysql openx’ provabck/

This command won’t work as multiple db selection is not allowed.

innobackupex --include=‘aggiornamenti’ provabck/

will generate the size of ibdata1 table redundancy per backup  
in my case 1,3GB!

My setup is:

CentOS 5.8  
mysqld Ver 5.0.95 for redhat-linux-gnu on x86\_64 (Source distribution)  
Innobackupex v1.5.1  
xtrabackup v.2.0.3

any help will be highly appreciated.

---

<div class="post-metadata">

**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\
**Post date:** [October 16, 2012, 1:02am UTC](https://forums.percona.com/t/solved-partial-backup-database-selection-issues/2301/2 "2012-10-16T01:02:23Z")

</div>

Hi,

There is already open bug for --databases option as xtrabackup ignores it without --stream option.  
[URL][https://bugs.launchpad.net/percona-xtrabackup/+bug/569387[/URL]](https://bugs.launchpad.net/percona-xtrabackup/+bug/569387%5B/URL%5D)

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

---

<div class="post-metadata">

**Author:** ![mlnzigzag](https://avatars.discourse-cdn.com/v4/letter/m/7993a0/32.png) [@mlnzigzag](https://forums.percona.com/u/mlnzigzag)\
**Post date:** [October 30, 2012, 5:25am UTC](https://forums.percona.com/t/solved-partial-backup-database-selection-issues/2301/3 "2012-10-30T05:25:45Z")

</div>

Dear niljoshi,

your solution did work like a charm.

Thanks a lot for your support.

Prefixing the topic with [SOLVED]