mysqldump is missing for mysql database

已回答
Avatar
Permanently deleted user
创建于

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

Votes

2

分享

5 条评论
Avatar
vasily chernov
创建于

@...,

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

0
Avatar
Thomasghenry
创建于

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
Avatar
vasily chernov
创建于

Thomasghenry,

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

0
Avatar
Thomasghenry
创建于
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
Avatar
vasily chernov
创建于

I created an issue https://youtrack.jetbrains.com/issue/DBE-11930 based on you description.

0

请先登录再写评论。