Bug #26424 | Add ability to look at a database based on a point in time | ||
---|---|---|---|
Submitted: | 15 Feb 2007 20:52 | Modified: | 13 Mar 2007 20:25 |
Reporter: | Christopher Fulton | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: General | Severity: | S4 (Feature request) |
Version: | All | OS: | Any (All) |
Assigned to: | CPU Architecture: | Any |
[15 Feb 2007 20:52]
Christopher Fulton
[13 Mar 2007 11:54]
Sveta Smirnova
Thank you for the report. Seems this implemented already. Please read about MySQL Server Logs at http://dev.mysql.com/doc/refman/5.1/en/log-files.html
[13 Mar 2007 20:25]
Christopher Fulton
I don't really see how the logs implement this. I know that the binary logs will record all the updates/alters/changes and such, but what I was more looking for was to be able to then via a query, query the database based on a point in time (i know that you can effectively do this by simply restoring a backup from that day, and then using the binary log to do a point in time recovery up to the exact time you want, but I was hoping to be able to have a way to do this internally.) In other words, if I were to say SELECT * FROM FooTable WHERE FooId=1234 AS OF '2006-01-01', the database would run the query based on the data that was in the database on 2006-01-01.