From: Date: October 7 2005 3:03am
Subject: RE: mysqldump ONLY Schema
List-Archive: http://lists.mysql.com/mysql/190075
Message-Id: <25AD6215EF8A094182444A010D4A401F01D5A46F@snoexc03.asiapacific.cpqcorp.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

Hi Scott,

This is covered in the MySQL manual at

http://dev.mysql.com/doc/mysql/en/mysqldump.html

The option you need is -=20

 --no-data, -d

Do not write any row information for the table. This is very useful if
you want to get a dump of only the structure for a table=20

Regards


David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia

+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax


-----Original Message-----
From: Scott Klarenbach [mailto:doyouunderstand@stripped]=20
Sent: Friday, 7 October 2005 10:27 AM
To: My SQL
Subject: mysqldump ONLY Schema

I've used msyqldump to retrieve the structure and data of my db, but
can I use it to only spit out the structure, ie, the Create Table
statements, but none of the inserts.

Thanks.
Scott.

--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    =
http://lists.mysql.com/mysql?unsub=3Ddavid.logan@stripped