Hi Scott,
This is covered in the MySQL manual at
http://dev.mysql.com/doc/mysql/en/mysqldump.html
The option you need is -
--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
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]
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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
