I have 2 tables of identical structure in MySQL:
Table1 (the live table)
Table2 (the backup)
fields = id, a, b, c, d, e
Using PHP some fields in Table1 are editable by the end user. However I want to add a RESTORE button so that if they screw something up they can go back to the original data.
So I need a way (for example) to replace the entire row id=4 of Table1 with the original data from Table2
What is the best way to do this?