Weird issue with db schema generation when connected to a DO MySQL database

November 13, 2019 83 views
DigitalOcean Managed MySQL Database

Hi, I’ve opened a ticket but I thought I’d ask here as well in case someone can help. I havre a Rails app that connects to a database in my MySQL cluster managed by DO. If I run migrations on that database, the schema.rb file generated isn’t valid and cannot be used for example for loading into an empty db. If, however, I do exactly the same thing but with a local (Docker) instance of MySQL 8.0.17 - exactly the same version as DO - then all is good. Is there any Rails developer here who could try dumping the schema while connected to DO MySQL?

Thanks!

Be the first one to answer this question.