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:[EMAIL PROTECTED] 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]