From: Peter Brawley
Date: April 15 2005 2:56pm
Subject: Re: just dumping table definitions, not data
List-Archive: http://lists.mysql.com/mysql/182673
Message-Id: <425FD636.9040608@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

James,

>Is there a simple way to just get all the table definitions?

Use the mysqldump -d, --no-data option.

PB

-----

James Black wrote:

>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>Is there a simple way to just get all the table definitions?
>
>I have a bug in mysql connectorj and I want to send my stored procedure
>with the table definitions, but there are several tables used in it.
>
>This is with mysql 5.0.3, btw.
>
>Thanx.
>
>- --
>"Love is mutual self-giving that ends in self-recovery." Fulton Sheen
>James Black    james@stripped
>-----BEGIN PGP SIGNATURE-----
>Version: GnuPG v1.4.1 (MingW32)
>Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
>
>iD8DBQFCX9PWikQgpVn8xrARAvynAJ9B4ffkvm8HZ087LPgahWeBdvgRwQCfX5Wc
>lrboWqDiso5uzOfoFxz+EMA=
>=3hFf
>-----END PGP SIGNATURE-----
>
>  
>


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.11 - Release Date: 4/14/2005