From: bars0.bars0.bars0
Date: January 24 2012 10:02am
Subject: Copying data from one to another MySQL sesrver
List-Archive: http://lists.mysql.com/mysql/226654
Message-Id: <4F1E81B6.3030407@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Hi all!

I need to copy data (result set from query) from one server to another.
This will be done once a month (so cron will be involved:), for data 
from previous month.
Any ideas how can I achieve this?

Should I export query as INSERT SQL statement first and next read that 
exported file, or there is some other solutions?