When attempting to import data from an SQL file export following the mysql command line instructions for managed db, I receive ERROR 1102 (42000): Incorrect database name ' '
I copied the connection details using flags option from the dashboard and I’m connecting from one of the trusted sources. The name ’ ’ does not match the db I’m copying into or the source db/name in the sql file.
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!
Hi there,
Can you share the exact command that you are running here? Make sure to hide any sensitive information like passwords and etc.
Also, it is possible that there is a special character in the password causing the problem. What I could suggest is wrapping the username, the password and the database name in single quotes to make sure that the special symbols do not cause the problem.
Regards, Bobby
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.