Recognition

Contributions

5 Contributions
  • 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...
    1 By omercohen DigitalOcean Managed MySQL Database
  • 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...
    1 By omercohen DigitalOcean Managed MySQL Database
  • 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...
    1 By omercohen MySQL Databases DigitalOcean Managed MySQL Database
  • 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...
    1 By omercohen DigitalOcean Managed MySQL Database
  • 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 ...
    1 By omercohen Nginx MySQL WordPress