omercohen
11 contributions
10.8k contribution views
Recognition
Posts
-
Published Question
upgrading from php7.0 to 7.3
Hey, I'm having trouble with upgrading my PHP version from 7.0 TO 7.3 I'm getting an error when trying to install PHP 7.3 using YUM ``` Error: Package: php70u-fpm-httpd-7.0.32-1.ius.centos7.noarch (@ius) R... -
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...Accepted Answer: Hi there @omercohen, I believe that right before the Access denied; statement, you should have an Error Number followed by the exact line in the .sql file which is causing this error. Usually, it should look something... -
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 ...