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

Clone a DB

EmergeBrandonEmergeBrandon ContributorInactive User Role Beginner
I have database text_production and I want to create a database called txt_development with the same information. I have a 3 node Galera cluster with percona 5.6, I dont want to cause any galera locks. So I dont think I can just dump the data from the production db right into the development db. Is there an easy way to do this. The DB is ~53GB.

Any ideas?

Comments

  • EmergeBrandonEmergeBrandon Contributor Inactive User Role Beginner
    So I have a dump of the DB now, I just want to import it into a brand new DB, can I just create the new DB and import the file with mysql dump? Im just affraid of locking up galera.
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.