We are in the process of migrating a Managed MySQL 8 database hosted in an agency DigitalOcean cluster into our own DigitalOcean account.

I have read the documentation and can’t seem to find the preferred process for this type of migration.

Ideally, there would be a way to simply transfer ownership of the database.

Failing that, we would like to set up the managed database in our account to run in parallel to the agency version of the database in order to eliminate downtime when the website configuration is swapped.

Is there a preferred approach?

I see the “Move To” option in this tutorial: https://www.digitalocean.com/docs/databases/mysql/how-to/restore-from-backups/
I am not able to test the migration from the perspective of the agency account and so could use some guidance.

Thank you for any guidance you can provide!

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.

×
Submit an Answer
1 answer

Hello @brk21

The “Move To” option under “Actions” is to move the Managed MySQL Database to a project of your choice in the same account. There is no direct option to move the Managed MySQL database from one account to another.

The recommended option would be to
1) Create the new Managed MySQL database in the account to which you wish to move the database.
2) Export the database from the agency DigitalOcean cluster.
3) Import the database to the newly created Managed MySQL database.
4) Please make sure it’s completely imported then update the database credentials in the website configuration to switch without any downtime.

Tip: Please destroy the database from the agency DigitalOcean cluster only after confirming the migration is successful.

Export and Import database

Cheers,
Dikshith