mysqlsqlrecreate

How to get query that would recreate sql table in PHPMyAdmin


I have table on MySQL server and would like to get the SQL that would re-create the table.

How do I get the query to recreate the SQL table?


Solution

  • mysqldump can do it - http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

    You can use it like this:

    mysqldump [databasename] [tablename] > mysqltablesql.sql