Tristan Tristan - 1 year ago 57
SQL Question

Create MySQL query to create a table from an existing table

I have quite a large and complex table in a MySQL database that would be a pain to have to build a query for manually to recreate if anything went wrong.

Is there someway I can get MySQL or some other tool/script I can use to get a Query made automatically that would recreate the structure of the table?

Ideally if you suggested a tool/script it would be for Linux

hop hop
Answer Source

Also any backup method like mysqldump should give you an option to save structure as well as data.