How to full copy mysql table to different host/database with data and all keys?

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?

2 comments
Comment actions Permalink

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

 

0
Comment actions Permalink

Why we can not copy tables with indexes?

0

Please sign in to leave a comment.