Is it possible to get back to older state with binlog but no backups?

[Benjamin Weser]

Hello everybody,

to keep it short:
Today I imported a new backup file of our production system into my local development system. The problem was that there were already lots of new feature in the development system which I've overwritten with the production data.

I had turn on the binlog. But the problem is, my last backup from development was on Nov, 11th, the first binlog started at about Nov, 19th because I have updated my MySQL-Server on that day (and probably started logging on that day which I haven't done before).

All my changes on the system take part between Nov, 11th and 19th. So I have no backup containing them.

So is there a possibility to use the binlog for a kind of rollback of the changes I made today?

Thanks for the answer in advance.


Edit: I thought about it once more... and since I don't think that there are any backups made by MySQL except the once I did myself, this wouldn't work... :( Seems I have to do develop again what I've overwritten in 5 sec today... :(



Edited 1 time(s). Last edit at 12/28/2007 05:36AM by Benjamin Weser.