Bug #76910 Keep original table after ALTER TABLE with ALGORITHM=COPY
Submitted: 1 May 2015 12:07
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Open Impact on me:
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any

[1 May 2015 12:07] Daniël van Eeden
It would be nice to be able to run an alter table which copies the table and then keep the old table with ${tablename}_copy or somthing similar. This makes it easy to rollback with RENAME TABLE

This doesn't include new changes, but for those binlogs might be used.

This is especially handy for DROP COLUMN actions.

How to repeat:
See description