Menu
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!
366
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.
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.
There can be two ways.
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.
104
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
