What about export as SQL UPDATE
| User, date | Message |
|---|---|
|
Written by Ingekr
1 year 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
1 year ago 2 posts since Tue, 21 Feb 12 |
Looks like it exist |
|
Written by jfalch
1 year ago 241 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 jfalch
1 year ago 241 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. |