Hassan, By Murphy's law, they WILL get corrupted if you don't have a backup. You need a current backup, or you need an older backup and a way to redo the updates.
That said, if you do a FLUSH TABLES after your update, then corruption is unlikely--no more likely than for any other OS file. After an update to a MyISAM table and before doing a FLUSH TABLES, you can easily get corruption on, say, a power failure. (This is observed behavior, despite a claim in the manual that the data are written to disk after the update statement. The data file is incompletely written, so myisamchk doesn't recover it.) > From: "Hassan Shaikh" <[EMAIL PROTECTED]> > To: "MySQL List" <[EMAIL PROTECTED]> > Subject: MyISAM Table Corruption > Date: Tue, 3 Feb 2004 12:50:29 +0400 > What are the chances of MyISAM tables corruption when the table is > update rarely? (Once in a 60+ days). It's basically a lookup table > used mainly in SELECT statements. > Thanks. > Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
