It will be in the 3.2 manual - I didn't know about it before now :) Nicole 2010/1/10 Jesse <pianohacker@gmail.com>:
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@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@tamil.fr> Subject: Re: [Koha] Culling old session data To: Rick Welykochy <rick@praxis.com.au> Cc: Koha-List <Koha@lists.katipo.co.nz> Message-ID: <4B4865D9.9040803@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Jesse Weaver
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha