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

What about export as SQL UPDATE

Ingekr posted 3 years ago in General
Would be very usefull to bring a table back to a point in time.

Regds
Inge
Ingekr posted 3 years ago
Looks like it exist
jfalch posted 3 years ago
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 posted 3 years ago
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.