List:General Discussion« Previous MessageNext Message »
From:Eric Berg Date:March 30 1999 11:17pm
Subject:Re: How do I generate DDL for MySQL database
View as plain text  
Thanks, Alistair,

I looked, but didn't find the answer.  This might be a good FAQ.

-Eric.

Alistair MacDonald: [Wednesday 31-March]:

> 
> 
> On Tue, 30 Mar 1999, Eric Berg wrote:
> 
> > Data Definition Language -- SQL text that will create the tables and indices
> > for an existing database.
> > 
> > I'm looking for a script that will look at an existing database and generate
> > this from the "show tables", "show columns" and "show indexes" for that
> > database.
> 
> Well, apart from the fancy tests for the existance of the database
> (non-standard) you could try:
> 
> mysqldump -d <databasename>
> 
> (Read the manual for full details, but it dumps the contents of the
> database without the data ie just the structure)
> 
> Alistair
> 

-- 
Eric Berg
Chief Technical Officer, iParty Corp.               eberg@stripped
Vice President, New York Linux Users Group           eberg@stripped
work: 212-331-1229                          http://doobie.iparty.com
home: 212-721-2872
Thread
How do I generate DDL for MySQL databaseEric Berg30 Mar
  • Re: 64bit to 32bitCraig Huffstetler22 Mar
Re: How do I generate DDL for MySQL databaseEric Berg31 Mar
  • Re: How do I generate DDL for MySQL databaseAlistair MacDonald31 Mar
    • Re: How do I generate DDL for MySQL databaseEric Berg31 Mar
Re: How do I generate DDL for MySQL databaseEd Carp31 Mar
  • Re: How do I generate DDL for MySQL databaseEric Berg31 Mar
Re: How do I generate DDL for MySQL database(Eric Berg)31 Mar