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?
maintenance --> optimize Database as sh script or cron
Re: maintenance --> optimize Database as sh script or 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
so you can run this query using mysql command line BUT rather then doing this I think there's much better idea - update mysql
Don't forget to run script update