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

Multiple DataBases

lflacayolflacayo EntrantInactive User Role Beginner
Hi All,

Working in a scenario where we have ~20 databases on a single instance of myql (Percona 5.1), I have 3 servers, a prod, a reporting (replicating from prod) and a test environments. Right now I do dumps of each database and keep a copy of it from the reporting server and keep the dumps for a week. From time to time, I have to copy the data from prod to the test server. so I zcat the compress dump file and load it into the test.

This process works fine, but I am thinking that using XtraBackup would work better.

So my questions are these: Can I do something similar to mysqldump on each database and have separate files for each? How can I import just one database into the test server.

Thank you in advance.

Luis

Comments

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.