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.



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.