MySQL Forums :: Backup :: Backup and trimming data idea


Advanced Search

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 2194 newbie Shai 06/22/2012 07:34PM
Re: Backup and trimming data idea 1245 Rick James 06/23/2012 05:23PM
Re: Backup and trimming data idea 1314 newbie Shai 06/23/2012 05:36PM
Re: Backup and trimming data idea 1335 Rick James 06/24/2012 01:51PM
Re: Backup and trimming data idea 1330 newbie Shai 06/25/2012 10:16AM
Re: Backup and trimming data idea 1194 Rick James 06/26/2012 08:14AM
Re: Backup and trimming data idea 1248 newbie Shai 06/26/2012 08:46AM
Re: Backup and trimming data idea 1158 Rick James 06/27/2012 08:36AM
Re: Backup and trimming data idea 1274 newbie Shai 06/27/2012 09:03AM
Re: Backup and trimming data idea 1157 Rick James 06/28/2012 11:19PM
Re: Backup and trimming data idea 1138 newbie Shai 06/29/2012 07:12AM
Re: Backup and trimming data idea 1166 Rick James 06/30/2012 11:50AM
Re: Backup and trimming data idea 1221 newbie Shai 07/02/2012 09:47AM
Re: Backup and trimming data idea 1166 Rick James 07/03/2012 01:32PM
Re: Backup and trimming data idea 1128 newbie Shai 07/05/2012 11:13AM
Re: Backup and trimming data idea 1261 Rick James 07/06/2012 09:57AM
Re: Backup and trimming data idea 1149 newbie Shai 07/07/2012 10:50AM
Re: Backup and trimming data idea 1177 Rick James 07/08/2012 09:33AM
Re: Backup and trimming data idea 1157 newbie Shai 07/16/2012 08:08PM
Re: Backup and trimming data idea 1181 Rick James 07/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.