CODEWITHSUNDEEP
mysqldatagrip
Siricks
Siricks

Reputation: 421

How to export a data base from DataGrip at one SQL file?

How I can export a data base from DataGrip at one SQL file as phpmyadmin export?

If I use Dump Data To Files, DataGrip save one table at one file.

And how I can create backup of all MySQL databases, which open in DataGrip?

Upvotes: 42

Views: 81272

Answers (4)

Kirill
Kirill

Reputation: 73

You can now tick "Single File" while choosing "Dump Data to File(s)" in DataGrip 2018.3.1enter image description here

Upvotes: 3

Daniel L
Daniel L

Reputation: 632

Old thread here, but for those who may stumble upon it, the newer versions of DataGrip have a new option, "dump with mysqldump", that will let you generate a dump contained in a single .sql output file.

enter image description here

Upvotes: 36

ulrichenslin
ulrichenslin

Reputation: 1023

Running DataGrip 2016.2.5 you can select sever tables and right click->Copy DDL. That puts a drop/create script on the clipboard, which you can then paste into a text file.

Upvotes: 14

groundh0g
groundh0g

Reputation: 406

I just got the DataGrip 2016.2.1 update this morning. It looks like the feature has been added (at least for SQL SERVER, the only one I tested). It wasn't available in the previous version - I tried.

Select a range of tables and right-click on them, or right-click on the database name. The Dump Data to Files option is now there.

Unfortunately, it still dumps to multiple files. But it beats the heck out of right-clicking on each table in turn.

Upvotes: 5

Related Questions