distal-attribute
distal-attribute
distal-attribute
distal-attribute

What about export as SQL UPDATE

User, date Message
Written by Ingekr
3 years ago
Category: General
2 posts since Tue, 21 Feb 12
Would be very usefull to bring a table back to a point in time.

Regds
Inge
Written by Ingekr
3 years ago
2 posts since Tue, 21 Feb 12
Looks like it exist
Written by jfalchMoney, Euro
3 years ago
388 posts since Sat, 17 Oct 09
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).
Written by jfalchMoney, Euro
3 years ago
388 posts since Sat, 17 Oct 09
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.