MyBB Community Forums

some of my database tables have been crashed and my forum stopped for hours because i was a way and not be able to repair crashed tables so im asking if there any mods or code or script to auto repair my forum database every hour without doing it myself.

Suggestion...change the sessions table to memory/heap and that will prevent the session table from crashing.

I think this was attached a while ago by Chris Boulton..

Download the attached file, upload it to your forums directory and call it via your browser. For example, http://www.mydomain.com/forums/repair.php

I don't think that works...I had a crash this week and tried to test it. I still got session table error. I believe that's because the file uses global.php and that tries to use the session table..so from there it just errors.

This should work if you're on a free host: http://community.mybboard.net/showthread.php?tid=25171

If you're really concerned that repairing may take too long, you can place additional lock checks - not hard to do.

Quote:This should work if you're on a free host:
http://community.mybboard.net/showthread.php?tid=25171

im on paid hosting "servage", i used this way since month ago and problem still exists.

so im asking if there any script or mod i add my database info "server,username,password" and database repaired every hour using javascript timer or any other way, if anyone can do this script it will be a good thing because many people have this crashing problems.

You can use a Cron job for that.

Quote:You can use a Cron job for that.

how to do that, could you explain it step by step please.