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]
