By omercohen
Hey,
I’m having trouble with importing my production cluster to staging on digital ocean managed database
I use mysqldump with --routines --triggers --events --all-databases &set-gtid-purged=OFF parameters
every time I try to import the SQL file to my staging cluster, I’m getting the message saying I need at least one superuser privileges after looking inside the backup file I can see that at the beginning of the file there are a couple of conditional comments (‘/* 50606’)
If I comment that out, the problem resolves, however, the file is way too huge to edit if I try to use vim or some other text editor it just crashes and returns me to the shell
Is there any flag or way to remove these comments? I know what they do, but in my case, it’s harmless to remove them at this moment the only thing that works for me is transferring the file to my pc and editing it with some third party text editor, but it’s just time-consuming and not-efficient
So far, I tried using --skip-comments, and that didn’t help.
I’m trying to remove this line right here.
/*!50606 SET GLOBAL INNODB_STATS_AUTO_RECALC=OFF */;
P.S I’m exporting this file from another managed database, so I have no idea how did we manage to import it with that line in the first place
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
Hi there @omercohen,
Have you tried using the --compact flag?
As a workaround, what you could also try is when running the MySQL import to specify the -f flag so that it would force the import even if there is an error.
Regards, Bobby
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.