Devart Forums

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

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.