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

Copying/Cloning database in Datagrip(MySQL)

Tags:

database

mysql

datagrip

Please do not close this question! My problem is simple and can be answered, I just do not have much experience with Datagrip. All I want to know is, how I can copy a schema to another schema I've created, essentially creating a clone of the original. For some reason my CMD prompt is not set for MySQL, there has got to be an easy way to do this within the Datagrip user interface, someone please help, thank you!

like image 366
Jugo Lugara Avatar asked Apr 29 '20 23:04

Jugo Lugara

People also ask

How do I copy a database in DataGrip?

Right-click a table and select Copy Table to… ( F5 ). In the Choose Target dialog, type the name of a schema in which you want to create a copy. In the Import <table_name> Table dialog, ensure that mappings are correct and click Import.

How do you duplicate a database?

Expand Databases, right-click the desired database, point to Tasks, and then select Copy Database... If the Welcome to the Copy Database Wizard splash page appears, select Next. Select a Source Server page: Specify the server with the database to move or copy. Select the authentication method.

1 Answers

There can be two ways.

  1. Reliable and with data, but requires my_sqldump. Context menu of the schema -> Export with mysql_dump. After that, on your new schema go to Context menu -> Restore with mysql_dump.

enter image description here

  1. Works if your schema does not contain some very specific objects: LOGFILE GROUP, SERVER, SPATIAL REFERENCE SYSTEM, TABLESPACE. And with no data. Go to the context menu of the schema -> Sql Scripts -> SQL generator. There you will see the script to create the schema from scratch. Just run it on your new schema.

enter image description here

like image 104
moscas Avatar answered Sep 19 '22 15:09

moscas
Sign in to Comment

Related questions

Laravel Scout - observe relations
All data is not inserted in MySql instance using Entity Framework Core
SQLAlchemy error when adding parameter to string SQL query
In what context is the MySQL keyword 'one' used?
Persisting MySQL data in Docker
MySQL : group by column and get date range
Proper connection string to pass to sqlalchemy create_engine() for mysql AWS RDS
Best practice to create a Summary Table for an ever-growing table in MySQL
How to find the closest value in PHP
How to do cascading inserts with tables having auto increment id columns in TypeORM
Symfony and Doctrine making migration with no effect
laravel how to use force index in eloquent
Generating liquibase xml file from current database
MySql localhost vs Amazon RDS instance Performance
Setting secure_file_priv to local folder in MySQL 8.0 (Mac OSX)
MySQL Utilities with MySQL 8 Server
Symfony 4 connection on Mysql docker container
Ignore duplicate entries and commit successful ones on DbContext.SaveChanges() in EF Core
PHP 7.4 & MySQL: caching_sha2_password Denying long (20c) passwords

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!