om: "Scott Helms" <[EMAIL PROTECTED]>
To: "Rudi Ahlers" <[EMAIL PROTECTED]>
Cc: "VpopMail" <[EMAIL PROTECTED]>
Sent: Wednesday, July 30, 2003 4:26 PM
Subject: Re: [vchkpw] SQL data
Rudi,
Here is the base way of doing it without any data.
mysqldump
Rudi,
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:
http://www.mysql.com/doc/en/mysqldump.html
Scott Helms
On M
On Monday 30 July 2001 15: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
>
man mysqldump
...
-d|--no-data
No row information.
---
so i assume mysqldump -d databaseyo