How to duplicate a MySQL table, indices, and data?

How do I copy or clone or duplicate the data, structure, and indices of a MySQL table to a new one? This is what I've found so far. This will copy the data and the structure, but not the indices: ```sql create table {new_table} select * from {old_table}; ``` This will copy the structure and indices, but not the data: ```sql create table {new_table} like {old_table}; ```