MySQL Forums
Forum List  »  Backup

Backup and trimming data idea
Posted by: newbie Shai
Date: June 22, 2012 07:34PM

We have a main table called tblLink in it will have a data field.The tblLink will have its primary key as foreign in few other tables too and one of the table will tblMainData which over time will be in million of rows. So we would like to maintain only 3 months of data. The rest we would like to purge and keep it to generate history reports. What is the best mechanism to go about in this scenario? Should we run a cron job to keep deleting data which is more then 3 months old but then how to store in .sql file is it?

Options: ReplyQuote


Subject
Views
Written By
Posted
Backup and trimming data idea
2433
June 22, 2012 07:34PM
1277
June 23, 2012 05:23PM
1347
June 23, 2012 05:36PM
1381
June 24, 2012 01:51PM
1369
June 25, 2012 10:16AM
1230
June 26, 2012 08:14AM
1360
June 26, 2012 08:46AM
1194
June 27, 2012 08:36AM
1311
June 27, 2012 09:03AM
1192
June 28, 2012 11:19PM
1172
June 29, 2012 07:12AM
1202
June 30, 2012 11:50AM
1256
July 02, 2012 09:47AM
1200
July 03, 2012 01:32PM
1163
July 05, 2012 11:13AM
1305
July 06, 2012 09:57AM
1188
July 07, 2012 10:50AM
1206
July 08, 2012 09:33AM
1193
July 16, 2012 08:08PM
1209
July 21, 2012 10:57PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.