copy tables structure + data...send to a url and then issue that command on that server
Posted: 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
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