MYSql copy tables

create table tablename_new like tablename; -> this will copy the structure…

insert into tablename_new select * from tablename; -> this would copy all the data