2 ms·
How about just using MySQL to archive the data. You can compress old tables to read only data sets. Otherwise using MySQL dump to a CSV (or any other format)
by captaincrunch 15y ago
How about just using MySQL to archive the data. You can compress old tables to read only data sets.
Otherwise using MySQL dump to a CSV (or any other format) would work well also.
- glalitha 15y agoThanks for replying. I created the script using mysql. But I need an opensource tool that can copy the data from live DB to archive DB (has the same structure of live db) efficiently and the archived data should be accessible through the web application. Basically, I need to update the Archive DB and delete old data from live DB.