Report this

What is the reason for this report?

Unable to import database from another managed database

Posted on February 12, 2020

Hey,

I’m trying to set up a staging Managed Database

So far I have Exported all my databases from the production Managed DB to an SQL file using mysqldump but when I try to import to the staging I stumble upon an error saying I need at least one super-user privileges (I Have used the default user doadmin) I even tried including the cert that was given to me but it didn’t help at all

Now I understand that DO won’t grant super-user access but It just doesn’t make sense why I can’t do this process

do I need to Include some special flag during export to overcome this issue?

 mysql -u doadmin -p   -h Staging-DB -P 25060 newDatabase < exportedDatabase.sql
Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation

And here’s the export command I executed

mysqldump -u doadmin -p -h Prod-DB -P 25060 database > database.sql

Thanks!

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Start building today

From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.