Duplicar uma tabela no MySQL é muito simples basta usar o comando create nomeando a nova tabela e indicando que ela deve se AS a tabela que se deseja copiar a estrutura e os dados. Um detalhe importante este comando apenas realiza a cópia de uma tabela pra outra mas não cria índices nem campos auto_increment. Se você desejar copiar todos os índices da tabela também você no lugar de AS usa LIKE.
CREATE TABLE new_table AS SELECT * FROM original_table;
Get a comprehensive overview on how to set up and design an effective database with MySQL. This thoroughly updated edition covers MySQL's latest version, including its most important aspects. Whether you're deploying an environment, troubleshooting an issue, or engaging in disaster recovery, this practical guide provides the insights and tools necessary to take full advantage of this powerful RDBMS. Authors Vinicius Grippa and Sergey Kuzmichev from Percona show developers and DBAs methods for minimizing costs and maximizing availability and performance. You'll learn how to perform basic and advanced querying, monitoring and troubleshooting, database management and security, backup and recovery, and tuning for improved efficiency. This edition includes new chapters on high availability, load balancing, and using MySQL in the cloud.