Export Database Structure sans data

2004-01-26 Thread David Perron

Im looknig for the function that will allow me to export the database
structure into a static file, without the actual data.
I would like to create an ERD diagram with the output file.

David


Re: Export Database Structure sans data

2004-01-26 Thread Daniel Kasak
David Perron wrote:

Im looknig for the function that will allow me to export the database
structure into a static file, without the actual data.
I would like to create an ERD diagram with the output file.
David

 

mysqldump -d

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


Re: Export Database Structure sans data

2004-01-26 Thread Adam Goldstein
phpMyAdmin also give a nice, simple frontend for doing this... copy 
tables or db's with/without data.

Personally, I don't think mysql should be used on a box without 
phpMyAdmin on it, at least as a backup admin tool;)
--
Adam Goldstein
White Wolf Networks
http://whitewlf.net

On Jan 26, 2004, at 5:05 PM, Daniel Kasak wrote:

David Perron wrote:

Im looknig for the function that will allow me to export the database
structure into a static file, without the actual data.
I would like to create an ERD diagram with the output file.
David


mysqldump -d

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
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]