title: MySQL - Duplicate a Table WITH Triggers
body: <p>I am trying to duplicate a table <strong>with</strong> triggers. I know that I've done this before, I just can't remember how I did it and where I learned how to do it. I've tried <code>CREATE TABLE newname LIKE oldname</code> and <code>CREATE TABLE newname AS oldname</code>, along with <code>CREATE TABLE newname SELECT * FROM oldname</code>. None of those queries seem to be copying triggers. I've followed <a href="https://stackoverflow.com/questions/8226734/how-to-duplicate-a-table-with-keys-other-structure-features-retained-in-mysql">this</a>, <a href="https://stackoverflow.com/questions/18017961/duplicate-a-table-including-indexes">this</a>, and <a href="https://stackoverflow.com/questions/766928/mysql-duplicate-table">this</a>, and again, no luck. Is there any way that I can copy triggers when duplicating/creating a new table?</p>