MYSql copy tables Posted on: April 27, 2011 by mindeater create table tablename_new like tablename; -> this will copy the structure… insert into tablename_new select * from tablename; -> this would copy all the data