Copy Data Between 2 Tables

[dirk mauroo]

I want to copy data between 2 identical tables. The 2 tables are in different database.

What is the easiest way to transfer data from one table to another ?

Thanks !

Dirk

[peterlaursen]

Do you want to 'handpick' specific rows to be copied or do you want to take everything existing in one table and insert into the other (and vice versa) if not there already?

[dirk mauroo]

I want to copy specific rows and complete tables.

[peterlaursen]

1) to transfer specific rows:

We plan an interactive/visual 'mode' of Data Synchronization. Something like a 'diff editor' if you know such. It will likely take around 3 months to release. If the databases are on different servers I do not see any option (except for manually comparing and inserting) with SQLyog now. If databases are on same server a single SQL statement like:

INSERT [IGNORE] INTO .one_db.one_table .. SELECT .. FROM other_db.other_table … [WHERE] ..

.. would do the job (details of how to frame the statement will depend on whether schemas are excatly the same). Refer MySQL documentation: http://dev.mysql.com…ert-select.html

2) transfer all rows

This is what we have Data Synchronization (in its current form) for.

Note: Data Synchronization is an ENTERPRISE/ULTIMATE feature.

[Author]

Posts