Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Import a database to DataGrip(0xDBE)

Tags:

mysql

datagrip

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

like image 937
Jonathan Solorzano Avatar asked Dec 19 '15 17:12

Jonathan Solorzano

People also ask

How do I import a database into DataGrip?

Navigate to the file that contains delimiter-separated values and double-click it. In the Import "file_name" File dialog, specify the data conversion settings and click Import. You can select in what schema to create a table and whether to import data to a new table or an existing one.

How do I clone a database in DataGrip?

Step 1: Choose the database which you want to clone. Step 2: Right click => SQL Scripts => Generate DDL to Clipboard. Step 3: Create a console file in destination DB => Paste DDL from the clipboard to it. Step 4: Run all scripts.

What databases does DataGrip support?

DataGrip is a database management environment for developers. It is designed to query, create, and manage databases. Databases can work locally, on a server, or in the cloud. Supports MySQL, PostgreSQL, Microsoft SQL Server, Oracle, and more.

1 Answers

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

like image 161
Karl Avatar answered Sep 24 '22 19:09

Karl
Sign in to Comment

Related questions

Can you GROUP BY with a CASE WHEN THEN alias name?
Transfer Mysql database to another computer [closed]
MySQL local variables
MySQL multiple columns in IN clause
Varbinary vs Blob in MySQL
InvalidRequestError: VARCHAR requires a length on dialect mysql
Selecting distinct 2 columns combination in mysql
Selecting first and last values in a group
Expression mysql NOW() in Doctrine QueryBuilder
What is the difference between <> and != operators in MySQL? [duplicate]
MySQL : retrieve a large select by chunks
Left join with condition
How to insert BLOB and CLOB files in MySQL?
Cronjob or MySQL event?
UTF-8 character encoding battles json_encode() [duplicate]
How to make sure there is no race condition in MySQL database when incrementing a field?
How to get Woocommerce Product Gallery image URLs? [closed]
SQL injection attack with php
Find out where your PHP code is slowing down (Performance Issue)
How to get the execution time of a MySQL query from PHP? [duplicate]

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!