omercohen
10 contributions
2.3k contribution views
Recognition
Posts
-
Published Question
removing conditional comments from sql backup
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 tim...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 erro... -
Published Question
Unable to import database from another managed database
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 err... -
Published Question
Tableau is unable to connect to Digital Ocean Managed Database
I'm having trouble with Tableau and connecting it to the DO Managed Database. The issue is whenever I want to create a new data source, it asks for my database credentials naturally I have to enter the username/pass... -
Published Question
Unable to execute a query without super admin
Hey, I have recently migrated my database to DO managed Database however I bumped into an issue that is very critical for me to resolve and would be happy if someone would explain how to overcome this issue I am cur... -
Published Question
Migrating my local DB to a remote DB
Hi! I want to move my local DB that currently resides with my Nginx web server what I did so far was: created a new DB cluster on DO exported my DB and imported it to the remote one I created a new droplet-based of ...