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]