How to archive a table after 3 months?

Databases
1

Hello,

I have a simple log table with data coming in, every 3 minutes from x sources.
That fills up and I’d need it for like 3 months for reports etc. and later on I would like to move the data to an archive (similar to piwik maybe) to save some rows in my active DB.

Any idea on how I’d do that? Simply INSERT SELECT or would it be better to compress it somehow? If so, how?

2

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.