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

Posted October 23, 2021
Laravel Git Deployment Building on DigitalOcean Development DigitalOcean GitHub Actions Databases

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.

captainabofficial

Submit an 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.

Priyanka Malik • October 23, 2021

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

Join the DigitalOcean Community