MySQL copy table data to a new table April 18, 2020 CREATE TABLE backup_table LIKE existing_table; INSERT backup_table SELECT * FROM existing_table;