DON'T USE 'CREATE TABLE XXX SELECT * FROM YYY' TO BACKUP AN INNODB TABLE

The reason is simple: the backup table will lose all key/index attributes from the original innodb table.