Here is the base way of doing it without any data.
mysqldump -d DATABASENAME > backup-file.sql
You can read this back into MySQL with:
mysql DATABASENAME < backup-file.sql
Check here for more options for mysqldump:
On Mon, 2001-07-30 at 09:20, Rudi Ahlers wrote:
> I know this is not entirely an SQL mailing list, but how do I dump only my
> database table layout? I don't want a dump of all the data
> Kind Regards
> Rudi Ahlers
> Océ Software Support
> +27 (11) 661-9000
> "The basic difference between an ordinary man and a warrior is that a
> warrior takes everything as a challenge while an ordinary man takes
> everything either as a blessing or a curse."