Hi,
I am using Digital Ocean MySQL database service with MySQL workbench to manage it (Version 8.0.22 build 107600 CE 64 bit).
I have succesfully connected to the database with MySQL workbench and can see my schema and tables. However i am not enable to reverse engineer my scheme into an ER model. When it imports the MySQL table objects it says:
Steps to reproduce
Does anyone have this issue and knows a solution for it?
Thanks in advance
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!
Accepted Answer
Asked DigitalOcean support and they managed to find a solution.
Remove ANSI_QUOTES from Global SQL Mode for the managed database server and it worked for me.
I found a “patch solution”. I export only the structure of the schema in question from the digitalocean database and, in a local environment on my computer, I generate the model from it. Not the optimal way, but it worked for me. I hope this helps you with something.
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
Stay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter.
New accounts only. By submitting your email you agree to our Privacy Policy
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.