Not the answer you need?
Register and ask your own question!

[SOLVED] Partial Backup: database selection issues

mlnzigzagmlnzigzag EntrantInactive User Role Beginner
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.

Comments

  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    Hi,

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

    You can either use a regexp matching all the desired databases with --include option.
    i.e innobackupex --include='^(aggiornamenti|corsi|corsi_storico|mysql|open)\. *' ...
  • mlnzigzagmlnzigzag Entrant Inactive User Role Beginner
    Dear niljoshi,

    your solution did work like a charm.

    Thanks a lot for your support.

    Prefixing the topic with [SOLVED]
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.