Auto Fix DB with crontab

make a new file named
fix.sh
put this code there:

Code:

---

#!/bin/bash
Directory=*

#CONFIGURATIONS:
        #Sleep Time:
        Time=1


for PIDS in $Directory
do
        OPEN="$PIDS"
                if [[ "$OPEN" != "fix.sh" && "$OPEN" != "dbtool" ]]
                then
                sleep $Time
                ./dbtool -r -s $OPEN -d $OPEN
                fi
done

---

Put the fix.sh and bdtool where your dbdata is on the server

then run a cron job to fix them auto :D:blushing:

What this do? '-'

It does manipulate your db while your server is running, it may damage them if they are not already. DBtool is supposed to be used to repair your db if you have problems, and not on a cron base..

Not a good idea.
That is, unless you want random rows dissapearing.

You dont wanna be messing with the database whilst the server is drawing and saving infomation to it.

As the other said before: not something to do. You don't want to rebuild the database whilst the server writes to it. At most you could do so each time the server is started.

Don't fix what isn't broke, that's just asking for troubles.

lol, this will kill your database..

this is useless