Menu
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?
480
Run the query on a MySQL database. This will generate an output in a grid format. Select the output of the query & click on the export/import option. Now provide a file name along with the format you want to export the data in.
In the list of objects, select the object that you want to create. Right-click a directory of the DDL data source in the Files tool window (View | Tool Windows | Files) and select New | SQL File. Type a CREATE statement in the created SQL file.
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.
185
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
