From: Baron Schwartz
Date: August 2 2007 10:20am
Subject: Re: KEEPING 3 MONTHS DATA ON SERVER AND ARCHIVE ALSO
List-Archive: http://lists.mysql.com/mysql/208369
Message-Id: <46B1AFE1.1050603@xaprb.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

krishna chandra prajapati wrote:
> Hi All,
> 
> I am working on the production server. I have been assigned the task of
> keeping 3 months data on the production server and archive the whole data
> also and move it to another system.(Innodb data)
> 
> Experts, Please give me the efficient way of do this task.

I use MySQL Archiver: http://mysqltoolkit.sourceforge.net/

Baron