Tristan Tristan - 1 year ago 67
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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download