CODEWITHSUNDEEP
mysqldatabasedatagrip
Nickknack
Nickknack

Reputation: 857

Making a local copy of a database

Currently I'm connecting to mysql databases on a dev server, but I want to make a copy of those databases on my local machine that I can connect to without connecting to the dev server. Is there an easy way to do this? I'm using DataGrip.

Thanks.

Upvotes: 5

Views: 3040

Answers (2)

moscas
moscas

Reputation: 10345

You can dump your schema from the context menu like on the picture

You can dump your schema from the context menu like on the picture

Upvotes: 2

JasonAMrtn
JasonAMrtn

Reputation: 63

I'm not familiar with DataGrip, but if you're using MYSQL, just log in on the website and go to your phpmyadmin, from there you can select the database you want, and click the EXPORT button, and you can choose the type of file to save it as. If DataGrip is a database tool, you should be able to save as an SQL file, otherwise maybe save as a CSV.

Upvotes: 1

Related Questions