MySQL HowTo Copy Duplicate a Table for backup purposes
This is a great way to test and experiment without risking your current table, or to make a backup of your current table to avoid corruption or dataloss due to malicious activity eg. deletion etc..
There are two steps and two commands
1.) Copy Table Structure
"cars_backup" is the new table and it will be a copy of the table called "cars"
CREATE TABLE cars_backup LIKE cars;2.) Copy Data To New/Copied Table
INSERT cars_backup SELECT * FROM cars;
Tags: