The sessions table tracks logins to the system, and can drastically slow your system down if it gets too large. You can safely truncate it entirely; doing so will disconnect anyone presently logged in but it sounds like you can’t log in at the moment anyway. There is a script (misc/cronjobs/cleanup_database.pl) which has an option to clear the table overnight as a cron job, to keep it from getting too big.
Jane Wagner Senior Project Manager LibLime, a division of PTFS Content Management and Library Solutions 11501 Huff Court North Bethesda, MD 20895 (301) 654-8088 x 151 jwag...@liblime.com <jwag...@ptfs.com> *From:* koha-boun...@lists.katipo.co.nz [mailto: koha-boun...@lists.katipo.co.nz] *On Behalf Of *ed c *Sent:* Friday, January 13, 2012 11:57 AM *To:* koha@lists.katipo.co.nz *Subject:* [Koha] Sessions table corrupt in Koha 3.0 I am trying to work on a small, older Koha (3.0.2)install that is not longer working. Koha is having issues connecting to the database after a problem with diskspace. While checking the Mysql and log files, I've come across with a problem with the "sessions" table in Koha. a CHECK TABLES on it or a REPAIR just hangs forever. They have backups so I should be able to restore the whole database (or possibly just this table) but before I do, does anyone have any other alternative solutions? What does this table do? Thanks, Edward
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
