Copy complete structure of a table in MySQL without using a backup?
You should be able to do :

CREATE TABLE `actor_copy` LIKE `actor`;


to get the structure, complete with indexes. However Foreign Keys will still need to be created manually.

The above will give you structure only. Then you can proceed to copy the data if you wish:

INSERT INTO `actor_copy` SELECT * FROM `actor`;