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.
Click below to sign up and get $100 of credit to try our products over 60 days!
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