Fairly new install and suddenly after few tweaks and installs not related to msyql I had the sys_session: Error File './dbispconfig/sys_session.MYD' not found (Errcode: 2) Couldn't get into MySQL or auto-repair nor did the: Code: CREATE TABLE `sys_session` ( `session_id` varchar(64) NOT NULL DEFAULT '', `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `session_data` longtext, PRIMARY KEY (`session_id`), KEY `last_updated` (`last_updated`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; Emaill was down, not working, I ended up deleting dbispconfig database, Uninstall ispconfig3, reinstall IPSConfig3, exact same settings, and re-wrote the "database" with a previous day backup we had. Wondering if there were any other steps needed to check on but so far everything is working just fine. This is right before our full server weekly backup would have kicked in .. but so far so good.
It might be that the create_table did not work as as only a prt of the table was missing (the table consists of a myd and a form file), so mysql thought that the table was still there.
It pays off to have multiple backups, locally and on external service like S3 because it is a matter of a buck or two a month. Thank you, so far so good and all seems to be working.
