I am attempting to migrate from AWS to Digital Ocean but I have hit a brick wall with the managed databases. I cannot seem to find a way to alter the settings of the database instances like I can with AWS RDS service. This could be a serious problem in my attempts to migrate to DigitalOcean because the MySQL instance as configured is not compatible with the software I host due to some small settings that needs to be changed such as
sql_require_primary_key which is set to ON an I need that Off. I cannot import my databases.
This textbox defaults to using Markdown to format your 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.