we are doing a checksum on our Innodb tables before we shut the server down (Windows) so that when we restart, we can compare the before and after. the reason for this is we are encrypting files in between data collection sessions, and we are making double sure we haven't munged our data.
however, i noticed that with Innodb, we can get incorrect results. the first time we tried this on shutdown, the cheksums came back zero for tables i know we pushed data into. when we brought the system back up, the checksums were non-zero. does this have to do with the way innodb buffers its data? is there a way to get an accurate cheksum prior to shutting down? thanks Les -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]