Copy a table

[email protected] · Post by **[email protected]** » Mon 26 Mar 2007 16:14

Hello i ve got 2 mysql server S1 and S2 i want to copy the CLIENT table from S1 to S2 ( the same than INSERT INTO tbl_name [(col_name,...)]
SELECT .. but between 2 servers )

thanks
DAVID

Antaeus · Post by **Antaeus** » Tue 27 Mar 2007 13:11

There are many ways to do this. Some of them are listed below:

- setting MySQL replication between two servers (see MySQL Reference Manual for more information);
- copying files of the table from one server to another. In this case format of databases on both servers must be compatible;
- writing your own application that uses the TCRBatchMove component of MyDAC to copy data from one server to another.