[Koha] Koha Digest, Vol 51, Issue 15

[Jesse]

The script can truncate the sessions table and clean out old zebraqueue
entries.

It seems to have been backported to 3.0. No part of the script depends on
anything new in 3.2, so it should work fine in a 3.0.x install.

2010/1/9 Bob Birchall @ Calyx <bob at calyx.net.au>

> cleanup_database.pl is not described in either version of the manual:
> http://koha.org/documentation/manual/3.2/appendices/cron-jobs
>
> What does it do?  Will it break if used in 3.0 ?
>
> Thanks,
> Bob
> CALYX
>
> > Date: Sat, 09 Jan 2010 12:17:45 +0100
> > From: Frederic Demians <frederic at tamil.fr>
> > Subject: Re: [Koha] Culling old session data
> > To: Rick Welykochy <rick at praxis.com.au>
> > Cc: Koha-List <Koha at lists.katipo.co.nz>
> > Message-ID: <4B4865D9.9040803 at tamil.fr>
> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> >
> >
> > > Is there a periodic job that can be run to cull old sessions from the
> > > table? We don't want to backup all the useless session data every
> night.
> >
> > misc/cronjobs/cleanup_database.pl
> >
> > Or just before doing a backup command (mysqldump), you can truncate
> > session table:
> >
> >   mysql -u<kohauser> -p<password> <koha-db-name> -e 'TRUNCATE TABLE
> > sessions'
> >
> > --
> > Fr?d?ric
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>



-- 
Jesse Weaver
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20100110/670167b8/attachment.htm