That sounds an even better idea! Regards
--------------------------------------------------------------- ********** _/ ********** David Logan ******* _/ ******* ITO Delivery Specialist - Database ***** _/ ***** Hewlett-Packard Australia Ltd **** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED] **** _/ _/ _/ _/ **** Desk: +618 8408 4273 **** _/ _/ _/_/_/ **** Mobile: 0417 268 665 ***** _/ ****** ****** _/ ******** Postal: 148 Frome Street, ******** _/ ********** Adelaide SA 5001 Australia i n v e n t --------------------------------------------------------------- -----Original Message----- From: Foo Ji-Haw [mailto:[EMAIL PROTECTED] Sent: Friday, 10 February 2006 6:57 PM To: Dan Nelson Cc: David Logan; Heikki Tuuri; mysql@lists.mysql.com; Logan, David (SST - Adelaide) Subject: Re: Surviving MySQL crash >>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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]