List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 14 1999 3:59pm
Subject:Re: Cloning a table
View as plain text  
At 11:53 AM -0400 6/14/1999, Adam Sherman wrote:
>Is there any way to reverse engineer a table and generate the sql
>statements needed to recreated it?

mysqldump db_name tbl_name

If you only want the CREATE TABLE statement, and not the data, use:

mysqldump -d db_name tbl_name



mysqldump --help for more information.

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
Thread
Cloning a tableAdam Sherman14 Jun
  • Re: Cloning a tableDino14 Jun
Re: Cloning a tablePaul DuBois14 Jun