Sample Header Ad - 728x90

How do you copy a table from MySqlServer_A to MySqlServer_B?

4 votes
2 answers
4007 views
I have a daily task that collects data from 3 MySql Servers and then pushes that aggregate data back out to each of the servers deleting the previous days data. All servers are MySql. I would like to put this into a stored proc. I have been searching for a way to connect from one MySql Server to another, run a query, next server - rinse and repeat. Besides not finding any examples of a stored procedure that connects to another MySql server, my immediate impression is that this is not really acceptable, nor intended. I can select into an outfile which creates a CSV. Is there any way to force an Xml document instead? I don't want to have to read into a datatable just to get Xml. Of course, Xml won't work with the Bulkload method, will it? What are my realistic options? One concern about selecting into an outfile is the use of weird characters: ' , \ \\ & @ / // etc...how will those characters affect the Bulkload process?
Asked by IAbstract (231 rep)
May 31, 2011, 03:43 PM
Last activity: Mar 8, 2018, 07:02 PM