If you dabble with phpmyadmin as much as I do, then you know how just a few simple codes can make work much easier. There are two ways to copy a table in phpmyadmin. The first way is to make a dump copy of your table (export table) and then import with a new name The second way is much easier with the use of mysql CREATE command CREATE table newtable SELECT * FROM oldtable There may be a third way, but that is through mysql shell command