Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Please help to understand..

boris_shvartsmanboris_shvartsman EntrantCurrent User Role Beginner
Folks,

Our production is running Mysql and Percona for some time now.
I am rather new to Percona and trynig to setup a dev box where I don't need all the databases we have in production but just some of them.

In production Percona makes a FULL.0 file which dumps all the databases.

How can I change that to only make a backup of a few databases??

Being DBA for other systems for a long time I can only imagine how dumb do I sound..

Comments

  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    Hi,

    For taking a backup of selective databases, you can use mostly two utilities.
    1. mysqldump (http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html)
    2. xtrabackup (http://www.percona.com/doc/percona-xtrabackup/)

    If database size is small then mysqldump option is useful otherwise you should go with xtrabackup. Please refer above pages and let us know if you face any issue.

    Btw: for selecting specific databases for dump, you can use " -B, --databases" option with mysqldump and for doing the same thing with xtrabackup you can use "--include='^(db1|db2|db3|mysql)\. *'" option with regex.
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.