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

Written By
Re: Extract and Load in MySql
August 11, 2009 11:22PM
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.