有没有一种在 DataGrip 中执行 MySQL 数据库 SQL 转储的好方法? [英] Is there a good way to perform SQL dump of MySQL database in DataGrip?

问题描述

我正在尝试使用 JetBrains DataGrip 作为我的主要数据库工具.但是，我仍然发现自己使用 SequelPro for SQL Dump.原因如下:

I'm trying to use JetBrains DataGrip as my primary DB tool. However, I still find myself using SequelPro for SQL Dump. Here is why:

在数据库级别，我找不到任何 SQL 转储功能.唯一的选项似乎是复制 DDL"，它复制架构，但不复制内容.

On a database level, I couldn't find any SQL dump functionality. The only options seems to be "copy DDL", which copies the schema, but not the content.

在表级别，当然，我可以将数据导出为 SQL 插入.但后来似乎唯一的方法是将它从每个表中单独导出，这是不可接受的.另一个缺点是，当将数据导出为 INSERT 时，它会为每一行创建一个单独的 INSERT 语句.

On a table level, sure, I can export data as SQL Inserts. But then it seems the only way to do so is to export it from each table separately, which is unacceptable. Another downside is, when exporting data as INSERT, it creates a separate INSERT statement for each row.

我试图寻找插件，但找不到任何插件.DataGrip 用户，如果您想出了任何解决方案，请告诉我.Sequel Pro 的工作原理很吸引人，但我真的很想在一天结束时使用一个数据库客户端.

I tried to look for plugins, but couldn't find any. DataGrip users, if you came up with any solutions, please let me know. Sequel Pro works like a charm, but I really would love to use one database client at the end of the day.

附注.出于各种安全原因，SSH 连接到服务器并运行 sqldump 对我来说不是一种选择.

PS. SSHing to a server and running sqldump is not an option for me, for various security reasons.

推荐答案

在 2016.2 中有一些功能，如截图所示.2016.3 将与 mysqldump 集成.

In 2016.2 there is some functionality, check like in screenshot. 2016.3 will be integrated with mysqldump.

这篇关于有没有一种在 DataGrip 中执行 MySQL 数据库 SQL 转储的好方法?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！