Re: Archiving and Retrieving data using java with mysql

[Ijaz Rashid]

Hi bryan,

You can use archive engine for archiving old data from primary to secondary disk.
Create your table using partition on Date column.
When you don't need data of older duration on primary disk, move the partition to secondary disk using Symbolic Link "symlink".
Using Symbolic Link data will remain avilible at both primary and secondary disk within same table.

(Note: I did it on myisam using mysql 4.1, I implemented my own partitioing using different tables bcz partitioining was not avilible in 4.1)

ijaz