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
