What about export as SQL UPDATE

[expired user #6238]'s profile image [expired user #6238] posted 12 years ago in General Permalink
Would be very usefull to bring a table back to a point in time.

Regds
Inge
[expired user #6238]'s profile image [expired user #6238] posted 12 years ago Permalink
Looks like it exist
jfalch's profile image jfalch posted 12 years ago Permalink
AFAIK, there is nothing like AppleĀ“s Timemachine for MySQL unless you have a mac, at least not at the mysql system level.

Your best bet is exporting the table as SQL, with data and options DROP and CREATE for table selected (NOT selected for whole database!); this creates a snapshot of the table as an .sql file on your computer.

Using Query panel and "Load SQL file...", then F9, will bring the saved state back (overwriting the current state of table).
jfalch's profile image jfalch posted 12 years ago Permalink
PS: there IS a feature called "binlog api" in mysql v5.6 that probably would allow such snapshots, but I do not know of any frontend products using it, yet. Will also probably be non-trivial to implement.

Please login to leave a reply, or register at first.