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 1000 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, then for the archive data, i need to retrive it back for future use but cannot replace the new data. Hope someone can show me the example code on these.

rgds,
bryan

The archiving part you mentioned in the last part seems confused.

Archive to where? if you copy out the data to another table, like a log table, then the space-saving will not change.

"delete it after archive" -- I assume this means delete from the 1000/hr table what was copied-out <or archived>?

restore -- restore to where? I know it is not to replace the new data, so where will it go?

__________________
Use the force...read the source!!
WYCIWYG -- what you code is what you get!

This is what i want to ask but i prefere to archive it out as a file and compress it and save it to another data server machine.

yup, only the data already archive need to delete.

Any suggestion for this? if i just want to retrieve (not restore) the information from the archive server machine for reporting purpose, ist possible?

rgds,
bryan