mysqldump is missing for mysql database

Answered

Hi,

 

The 'dump with mysqldump' option seems to be missing for some of my sql databases. I can see it in one of my databases but not the recent ones that I've added recently.

I've used mysqldump with this datagrip numerous times in the past so I'm fairly sure that the path correct.

Thanks

5 comments
Comment actions Permalink

Daphne Adeane,

What do mean by 'for some of my sql databases' is different schemas or different databases?

0
Comment actions Permalink

Anyone else have a solution?

I can see the myqldump option for databases hosted on localhost, but not remote databases. Those same remote databases (same connection string) can be dumped effortlessly from navicat.

The serverTimezone suggestion does not work for me. With the serverTimezone set to UTC, I still do not get the mysqldump option, even after disconnecting and reconnecting. 

Thanks

1
Comment actions Permalink

Thomasghenry,

Could you provide any screenshots and specify sample jdbc url for data sources with missing `mysqldump` option?

0
Comment actions Permalink
For posterity, connection strings of the form driver:protocol://host[:port][?query]  work.
 
The form driver:protocol://user:password@host:port/db?query will import and populate the fields correctly, and connect, etc, but it breaks the mysqldump feature.
 
Also, using the latter form and deleting the db from the fields corrupts the connection string.
1

Please sign in to leave a comment.