[SOLVED] Partial Backup: database selection issues

MySQL & MariaDB Percona XtraBackup
1

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.

2

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]

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

3

Dear niljoshi,

your solution did work like a charm.

Thanks a lot for your support.

Prefixing the topic with [SOLVED]