krishna chandra prajapati schrieb:
> Hi Sebastain,
> 
> On my production server there is two year data. So the hard disk is nearly
> 60% full. It contains user data also. On the basis of data column, i have to
> keep only 3 months user data on the production server. I have to also
> archive whole data and move it to other system.

ok, this is your assigned task - but what is the problem?

on a daily basis sync your production data with backup server
and delete data on production server older than 3 month

this is an application problem - cause only the application knows how 'old'
data is

IMHO MySQL has no native function to swap out aging data

-- 
Sebastian

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to