How to full copy mysql table to different host/database with data and all keys? Follow
Answered
I do right click on the source table in the list of database tables. Then select "Copy table to..." in context menu.
In popup window i choose the target database, then press <OK>
In result I see table and data, but no keys and indexes in target database.
How to full copy mysql table to different host/database with data and all keys?
Please sign in to leave a comment.
If you're trying to backup and restore a database from one host to another, you may have better luck using mysqldump. You can learn more about this here:
Backup: https://www.jetbrains.com/help/datagrip/export-data.html#create-a-full-data-dump-for-mysql-and-postgresql
Restore: https://www.jetbrains.com/help/datagrip/import-data.html#restore-a-full-dump-for-mysql-and-postgresql
Why we can not copy tables with indexes?