Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Why are snapshots so slow Question Question
Duplicate Website Question Question

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.

Add a comment
captainabofficial
By:
captainabofficial

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Why are snapshots so slow Question Question
Duplicate Website Question Question

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
priyankamalik 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

Reply Report

Related

Looking for something else?

Ask a new question Search for more help