Bug #65861 flashback from binlog for MySQL
Submitted: 10 Jul 2012 5:49 Modified: 10 Jul 2012 11:43
Reporter: xiaobin lin (OCA) Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: DML Severity:S4 (Feature request)
Version:5.* OS:Any
Assigned to: CPU Architecture:Any
Tags: Contribution, Flashback

[10 Jul 2012 5:49] xiaobin lin
There is a related feature request here. http://bugs.mysql.com/bug.php?id=65178

In order to make the flashback feature can handle DDL operation (such as truncate/drop table), we need to do some modification inside the server.

Simply we can bak the table that will be dropped to a bak_database. And record  the `flashback statement` into binary logs.

How to repeat:
new feature

Suggested fix:
The patch include the content in Plinux's patch, a slight modification is done for support DDL flashback.
[10 Jul 2012 6:20] xiaobin lin
Base on 5.5.18

Attachment: 5.5.18_flashback_all.patch (application/octet-stream, text), 36.26 KiB.