HI all, We have a Koha instance that has way too many entries in the sessions table for reason I won't go since the "why" is unimportant. 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. cheers rick -- _________________________________ Rick Welykochy || Praxis Services If you have any trouble sounding condescending, find a Unix user to show you how it's done. -- Scott Adams
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
participants (2)
-
Frederic Demians -
Rick Welykochy