What possible events could cause a MySQL database to revert to a previous state?

Posted by justkevin on Server Fault See other posts from Server Fault or by justkevin
Published on 2010-03-05T17:21:32Z Indexed on 2010/03/08 0:32 UTC
Read the original article Hit count: 321

Filed under:
|
|

A client of mine recently had a strange event with their MySQL database. Several days ago, one database suddenly "went back in time". All the data was in the state it was in several months ago. Even most of the .MYD and .MYI files had timestamps from November.

Fortunately, the server is not in production yet, but we need to understand how it happened so it doesn't happen again.

I'm not a MySQL guru, but I couldn't think of a scenario that could cause the database to rewind like that short of restoring from a backup. What could have happened here? Where should I look for clues?

(Server is FreeBSD 6.4)

© Server Fault or respective owner

Related posts about mysql

Related posts about freebsd