SmartCJ Support Forum

How can I achieve the same thing:

maintenance --> optimize database

running as a .sh script via cron job?

I am dealing with corrupted databases time after time because I have MYISAM tables (my mysql version does not support innodb)

So can I please run repair service function somehow by cron?

Basically "optimize Database " = sql query "REPAIR TABLE table_name"
so you can run this query using mysql command line BUT rather then doing this I think there's much better idea - update mysql