Re: Surviving MySQL crash

[Foo Ji-Haw]

>>15 * * * * /usr/local/mysql/bin/mysql -u root -pxxxxxx -e 'FLUSH TABLES'
>>
>>This would run a FLUSH TABLES once every hour at 15 minutes past. If you 
>>are using Windows, sorry I'm not sure how to do it there.
>>    
>>
>
>Easier to just set flush_time=900 in my.cnf :)
>  
>
Thanks guys. Will give it a shot.