Hello, Thanks for the suggestion Vijay as i was thinking on the same direction as well.
I will go with your suggested approach. Thanks spameden for you kind support as well. Regards Tapan Thapa On Tue, Apr 3, 2012 at 11:03 AM, Vijay kumar Dadhich <[email protected]>wrote: > HI Tapan, > > According to my view, you should receive the dlr with in 12 to 24 > hours from operator. but in your present situation you can copy this > data in a new table or you can make (dump) backup this tables or > databases for your record. For the next time i suggest you , you take > a field as a current time stamp in dlr table, so you can truncate > /delete the data which have more then 12 hourse in table or whatever > time you select. > > On Mon, Apr 2, 2012 at 3:30 PM, <[email protected]> wrote: > > Send users mailing list submissions to > > [email protected] > > > > To subscribe or unsubscribe via the World Wide Web, visit > > http://www.kannel.org/mailman/listinfo/users > > or, via email, send a message with subject or body 'help' to > > [email protected] > > > > You can reach the person managing the list at > > [email protected] > > > > When replying, please edit your Subject line so it is more specific > > than "Re: Contents of users digest..." > > > > > > Today's Topics: > > > > 1. Kannel - DLR Storage - MySQL (Tapan Thapa) > > > > > > ---------------------------------------------------------------------- > > > > Message: 1 > > Date: Mon, 2 Apr 2012 13:25:29 +0530 > > From: Tapan Thapa <[email protected]> > > To: [email protected] > > Subject: Kannel - DLR Storage - MySQL > > Message-ID: > > < > cajalo3dtzus3j+bptcnehxurg_ga99r5q9wg+rxsiz4ju_x...@mail.gmail.com> > > Content-Type: text/plain; charset="iso-8859-1" > > > > Hello Community, > > > > I had enabled dlr-storage under kannel to store delivery report in mysql > > database and now dlr table is having more then 8 (.8 million) lacs > records. > > > > Can any one let me know how should i delete old dlr from database for > which > > i have not received the delivery report since last 10 days? > > > > Thanks in advance. > > > > Regards > > Tapan Thapa > > -------------- next part -------------- > > An HTML attachment was scrubbed... > > URL: < > http://www.kannel.org/pipermail/users/attachments/20120402/0b1b8a9e/attachment-0001.html > > > > > > ------------------------------ > > > > _______________________________________________ > > users mailing list > > [email protected] > > http://www.kannel.org/mailman/listinfo/users > > > > > > End of users Digest, Vol 68, Issue 6 > > ************************************ > > > > -- > Thanks & Regards, > > -Vijay Kumar Dadhich > Entrepreneur > [email protected] > >
