Import a database to DataGrip(0xDBE)

mysql datagrip
Jonathan Solorzano picture Jonathan Solorzano · Dec 19, 2015 · Viewed 24.7k times · Source

How do I import a database just like in phpmyadmin at DataGrip?

I have the .sql exported from phpmyadmin... but those are lots of lines so that the IDE stops working when trying to run the whole .sql

Answer

Karl picture Karl · May 9, 2017

In DataGrip go to File > Open and select your mysql dump file. Then right click the tab for the file to get the context menu, and select "Run [your filename...]" option. It may ask you to select your schema to apply the run to. But this is how I accomplished importing a dump from phpMyadmin using DataGrip.

enter image description here

Related questions

Creating new database in DataGrip JetBrains

Anybody know how to create new database in DataGrip (database IDE from JetBrains)? Could not find in DataGrip Help page.

Read More
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, …

Read More
How to import CSV data to MySQL in JetBrains DataGrip

I'm studying MySQL. I need to import data from a CSV file to a MySQL table using JetBrains DataGrip. I've done such this job before in dbForge MySQL, but last week I moved from Windows to Linux. There are some …

Read More