Backup/Restore Table Columns Export whole table (sql) Duplicate the table Truncate and insert the backup into the copy table Update from the copy table, matching rows