I ended up using mysqldump, worked well enough for what I was doing. I have to admit, I'm really surprised there's no way to do this directly in the admin gui that comes with MySQL though :).
Thanks all for the replies! -----Original Message----- From: Richard Heyes [mailto:[EMAIL PROTECTED] Sent: 18 February 2008 11:24 To: Esbach, Brandon Cc: MySQL User Group Subject: Re: Backup table structure, not data > Is there any way to backup a complete database structure > (tables/fields/indexes/etc), without the data? Or even get a creation > script per table? > > At present the only way I can think of is to restore a backup to > another server and just delete records (a legacy database with data > hitting over 12GB, might take some time) - but there's gotta be an > easier way to do it... mysqldump has a --no-data option. Try "man mysqldump" (assuming your MySQL server is Unix based. -- Richard Heyes http://www.websupportsolutions.co.uk Knowledge Base and Helpdesk software hosted for you - no installation, no maintenance, new features automatic and free -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]