can someone suggest how to repair this without telling me to ssh,
horde.horde_sessionhandler
Error : Can't find file: 'horde_sessionhandler' (errno: 2)
error : Corrupt
can someone suggest how to repair this without telling me to ssh,
horde.horde_sessionhandler
Error : Can't find file: 'horde_sessionhandler' (errno: 2)
error : Corrupt
Log in as root and type the following commands (in bold):
#mysql
#mysql> use horde
#mysql> repair table horde_sessionhandler;
The final command should return:
+----------------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+----------------------------+--------+----------+----------+
| horde.horde_sessionhandler | repair | status | OK |
+----------------------------+--------+----------+----------+
1 row in set (0.91 sec)
SOLVED
checked the main sql processes and
as it says its "in use"horde.horde_sessionhandler repair Error Can't find file: 'horde_sessionhandler' (errno: 2)
horde.horde_sessionhandler repair error Corrupt
deleted table and recreated with
log in now granted.Code: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;
i will let you know if i get issue with imap log in