[Koha] How to clean transaction table?

[SATISH]

Dear All,

Koha (3.16) has been installed from packages method  on ubuntu 12.4 LTS.
Since, it is testing machine, and
I would like to clean up all the transactions made under "PATRONS" ( for
all patrons)
1. Circulation history
2. E-mail Notiecs
3. Modification Log
and I am not sure how to go about this, Kindly share the mysql commands for
the same.

With Thanks
Satish
Librarian
Govt. Engineering College, Hassan.
Karnataka.
INDIA.





On Wed, Aug 14, 2013 at 7:40 AM, e-Libris Helpdesk <
elibris.helpdesk at gmail.com> wrote:

> Vimal,
> You should have delete privileges on your MySQL database.  I'm guessing you
> can truncate the circ and other transaction table by delete existing
> records.
>
> Just a thought.
>
> Regards,
> Jerry Brock
> e-Libris Technologies, LLC
>
>
> On Tue, Aug 13, 2013 at 4:32 AM, Vimal Kumar V. <vimal0212 at gmail.com>
> wrote:
>
> > Dear Friends,
> >
> > Today our Koha officially started in production mode.
> >
> > Trial transaction (checkout, checkin, fines etc) details are still in
> Koha.
> >
> > We wish to clean all transaction details from Koha and start the
> > transactions fresh from today.
> > If old transactions persist in Koha, auditors create problems at the year
> > end.
> >
> > How can we clean the transaction table and get ready for a fresh startup?
> >
> > Regards,
> > --
> > Vimal Kumar V.
> > Technical Assistant
> > Mahatma Gandhi University Library
> > Kottayam, Kerala- 686 560
> > Web: http://www.vimalkumar.info
> > Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in
> >
> ---------------------------------------------------------------------------
> > "I forget what I was taught. I only remember what I have learnt"
> > -Patrick White
> > _______________________________________________
> > Koha mailing list  http://koha-community.org
> > Koha at lists.katipo.co.nz
> > http://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
>
>
> --
> Jerry Brock
> e-Libris Technologies, LLC
> email: elibris.helpdesk at gmail.com <elibrishelpdesk at gmail.com>
> phone: 1-877-723-9447 ext. 2
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>



--