MySQL Forums
Forum List  »  Data Warehouse

Re: Extract and Load in MySql
Posted by: Rick James
Date: August 11, 2009 11:22PM

In what language?

If some programming language, establish 4 connections; read data from 3, write to the 4th.

If shell scripting, use something like
mysqldump -h source_1 ... | mysql -h dest ...
mysqldump -h source_2 ... | mysql -h dest ...
mysqldump -h source_3 ... | mysql -h dest ...

In either case, use cron to run it every few minutes.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Extract and Load in MySql
4768
August 11, 2009 11:22PM
4773
August 12, 2009 07:40PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.