Question

Moving from pgsql dev database to managed mysql database - App platform

Posted October 23, 2021 116 views
GitDigitalOceanDeploymentDevelopmentDatabasesLaravelBuilding on DigitalOceanGitHub Actions

Hey everyone, will I be able to move from my current dev database for my app platform (a pgsql database) to a managed mysql one?

I deleted the dev one and then I added a managed mysql one but when I run php artisan migrate I get an access denied error.

Is there any guide for transferring from a dev database to a managed database as I am also not sure what I do with the environment variables.

Thanks.

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 @captainabofficial

To upgrade dev database to managed database, please follow below steps:

Go to https://cloud.digitalocean.com/apps, click on your app, and click on the Settings tab.

Click the dev database you would like to upgrade to a managed database and click the Upgrade to a Managed Database button. You can choose the size of the machines that run your database with the Node Plan drop-down, and add standby nodes that stay synchronized and provide failover during downtime with the Standby Nodes drop-down.

Click Upgrade Database to complete the process.

For more details, please refer below link:

https://docs.digitalocean.com/products/app-platform/how-to/manage-databases/#upgrade-dev-database-to-managed-database

Hope that this helps.
Regards,
Priyanka