On my site was an error: General Error SQL ERROR [ mysqli ] - Table 'phpbb_sessions' is marked as crashed and should be repaired I could click to repair that table in mysql manager - PHPMyAdmin and that fixed it. Also the command is: REPAIR TABLE phpbb_sessions; But the question is how to prevent it. Someone said that MyISAM tables crash like this due to something unexpected, like a server failure, out of memory/disk space or breakdown. There is nothing i can do to prevent it if i am not a server admin. What if i am? Or maybe if i am just a shared hoting user with basic SSH access and cronjob, i can run a cron task executing a bash script containing: mysqlcheck -C / mysqlcheck -c If my server support InnoDB, should i convert just this one table (i found this one to be only one that gets crashed from time to time)? I found SQL command: ALTER TABLE table_name ENGINE=InnoDB; I would backup table_name before running that.
Maybe you could ask the hosting provider to move your site to another node if your current one has hardware issues.
>> General Error SQL ERROR [ mysqli ] - Table 'phpbb_sessions' is marked as crashed and should be repaired As mentioned it is a general error, unable to guess what exactly caused this. Possibilities: - Disk quota issues - Any sudden server reboots or database server restart. - Server running with resource shortage for long time - Unoptimized MysQL server - Unoptimized application/queries - Low physical memory(OOM error). 1. You should consult your host for a detailed investigation up on errors to ensure that it is not a hardware issue or an issues with any other underlying softwares on server supporting the application. If it is hardware or the server, then you can switch to a better server. 2. If not, it is application or database related, then you need seek assistance from developer's. 3. Please note that you should backup the code as well as database before making any changes to an active website.