Copy a MySQL table

Not using this all too often, so here it is for me and everyone:

create table my_new_table like my_old_table;
insert into my_new_table select * from my_old_table;

An easy way to make a quick backup.

Leave a Reply

Your email address will not be published. Required fields are marked *