Error:- Can’t find file: ‘horde_sessionhandler.MYI’
If you get this error, you’ve most likely done a file-based MySQL backup restore, and the InnoDB files are not present. The horde_sessionhandler table is an InnoDB table but not a MyISAM.
To fix this first you will need to stop mysql
# /etc/init.d/mysqld stop
Then remove the innoDB table
# rm /var/lib/mysql/horde/horde_sessionhandler.frm
Then start MySQL
# /etc/init.d/mysqld start
Now re-create the table:
# mysql -u admin -p`cat /etc/psa/.psa.shadow`
mysql>CREATE TABLE horde_sessionhandler (session_id VARCHAR(32) NOT NULL, session_lastmodified INT NOT NULL, session_data LONGBLOB, PRIMARY KEY (session_id)) ENGINE = InnoDB;
GRANT SELECT, INSERT, UPDATE, DELETE ON horde_sessionhandler TO horde@localhost;
