Question

Duplicate Database

Posted on November 8, 2024
MySQL DigitalOcean Managed MySQL Database
Asked by Roch Bajracharya

Hi everyone, I’m new to DigitalOcean and exploring its managed databases. I’m looking to create a duplicate of my existing database to set up a test environment, but I’m a bit unsure about the steps. Just to clarify, I don’t want to replicate the entire database cluster—only to duplicate the original database. Any guidance would be greatly appreciated. Thank you!

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

alexdo

Site Moderator

• November 11, 2024

Heya,

As mentioned you can create a new database and then simply export the current database and import the data in the new database.

https://docs.digitalocean.com/products/databases/mysql/how-to/import-databases/

Another approach will be to migrate the cluste. You can migrate existing on-premise or cloud hosted MySQL databases to clusters in your DigitalOcean account. Migrating a database establishes a connection with an existing database and replicates its contents to the new database cluster. If the existing database is continuously being written to, the migration process will continue until there is no more data to replicate or you manually stop the migration.

https://docs.digitalocean.com/products/databases/mysql/how-to/migrate/

Regards

KFSys

Site Moderator

• November 10, 2024

Heya,

What you can do is just download your Database and create another instance.

Here is a similar topic on the matter:

https://www.digitalocean.com/community/questions/how-to-download-a-database-from-managed-database-cluster