Archiving and Retrieving data using java with mysql

[bryan523]

Hi all,

I need your help on doing the archiving system using java with mysql.

I got one table which inside got a lot of data where all this data is the real time data and the data in this table will reach 10000 within 1 hour. The problem is, I dun want to stop the system but need to concernt the decrease of space memory.

what i need to do is archive the data for certain period and delete it after achive,the archive data will need to store as a file at another storage, then, i need to retrive it back to the databese for future reporting purpose but cannot replace the new data. Hope someone can show me the example code on these or the flow on how to do this.

rgds,
bryan



Edited 1 time(s). Last edit at 06/06/2006 04:59AM by bryan523 .