copy tables structure + data...send to a url and then issue that command on that server

ahlar64 · Post by **ahlar64** » Tue 22 Aug 2006 17:19

I am wondering what would be the best way to do this.

I want to do these steps.

1) Copy the structure and data of several tables from a local mysql server.

2) Send those structures and data to a url either through strings or a tstream (I have this part done)

3) At the server at that url send these strings or stream to a SQL server there (this part is also done too)

4) Use these strings / stream and write (overwrite) the tables on that MySQL server with the latest data and structures.

I am not sure as to how I would go about doing this.

---Dave

teunis · Post by **teunis** » Wed 23 Aug 2006 00:22

Are you using the functions:
TMyServerControl.BackupToFile and ,,,.RestoreFromFile ?

Antaeus · Post by **Antaeus** » Wed 23 Aug 2006 12:35

Another way is usage of TMyDump or TMyBackup components. Please see MyDAC help for detailed information.