The script can truncate the sessions table and clean out old zebraqueue entries.<br><br>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.<br>
<br><div class="gmail_quote">2010/1/9 Bob Birchall @ Calyx <span dir="ltr"><<a href="mailto:bob@calyx.net.au">bob@calyx.net.au</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<a href="http://cleanup_database.pl" target="_blank">cleanup_database.pl</a> is not described in either version of the manual:<br>
<a href="http://koha.org/documentation/manual/3.2/appendices/cron-jobs" target="_blank">http://koha.org/documentation/manual/3.2/appendices/cron-jobs</a><br>
<br>
What does it do? Will it break if used in 3.0 ?<br>
<br>
Thanks,<br>
Bob<br>
CALYX<br>
<br>
> Date: Sat, 09 Jan 2010 12:17:45 +0100<br>
> From: Frederic Demians <<a href="mailto:frederic@tamil.fr">frederic@tamil.fr</a>><br>
> Subject: Re: [Koha] Culling old session data<br>
> To: Rick Welykochy <<a href="mailto:rick@praxis.com.au">rick@praxis.com.au</a>><br>
> Cc: Koha-List <<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a>><br>
> Message-ID: <<a href="mailto:4B4865D9.9040803@tamil.fr">4B4865D9.9040803@tamil.fr</a>><br>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed<br>
><br>
><br>
> > Is there a periodic job that can be run to cull old sessions from the<br>
> > table? We don't want to backup all the useless session data every night.<br>
><br>
> misc/cronjobs/<a href="http://cleanup_database.pl" target="_blank">cleanup_database.pl</a><br>
><br>
> Or just before doing a backup command (mysqldump), you can truncate<br>
> session table:<br>
><br>
> mysql -u<kohauser> -p<password> <koha-db-name> -e 'TRUNCATE TABLE<br>
> sessions'<br>
><br>
> --<br>
> Fr?d?ric<br>
<br>
_______________________________________________<br>
Koha mailing list<br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Jesse Weaver<br>