Re: print database schema
Check out this program. Just wish there was an OS X version :-( http://www.datanamic.com/dezign/index.html -- greg willits -- [EMAIL PROTECTED] From: Steven Wren [EMAIL PROTECTED] Date: Tue, 29 Jan 2002 16:22:12 +1000 (EST) To: Paul DuBois [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: print database schema Hello more of a visual tool. The program I did see had views of all the tables as if you had done a describe table_name for each table, then had lines linking the relationships between tables (similar to what you can view in Access , even though i hate to admit I have used it :) would just be good for management and seeing where you can improve indexes etc... thanks. Regards, ___ Steven Wren [EMAIL PROTECTED] http://www.server101.com Webhosting and E-commerce Solutions Phone : AU (07)38766 101 US 877 7762 101 Fax : +61 7 38763 101 The world is not only stranger than we suppose, it is stranger than we can suppose. -J.B.S. Haldane On Tue, 29 Jan 2002, Paul DuBois wrote: At 14:42 +1000 1/29/02, Steven Wren wrote: Hello I was wondering if anyone knew of a program that would allow you to print out a complete database. I have seen it on a PostGre DB, so I am sure MySQL should have something... You mean mysqldump --no-data db_name ? cheers! Regards, ___ Steven Wren [EMAIL PROTECTED] http://www.server101.com Webhosting and E-commerce Solutions Phone : AU (07)38766 101 US 877 7762 101 Fax : +61 7 38763 101 The world is not only stranger than we suppose, it is stranger than we can suppose. -J.B.S. Haldane - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
print database schema
Hello I was wondering if anyone knew of a program that would allow you to print out a complete database. I have seen it on a PostGre DB, so I am sure MySQL should have something... cheers! Regards, ___ Steven Wren [EMAIL PROTECTED] http://www.server101.com Webhosting and E-commerce Solutions Phone : AU (07)38766 101 US 877 7762 101 Fax : +61 7 38763 101 The world is not only stranger than we suppose, it is stranger than we can suppose. -J.B.S. Haldane - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: print database schema
At 14:42 +1000 1/29/02, Steven Wren wrote: Hello I was wondering if anyone knew of a program that would allow you to print out a complete database. I have seen it on a PostGre DB, so I am sure MySQL should have something... You mean mysqldump --no-data db_name ? cheers! Regards, ___ Steven Wren [EMAIL PROTECTED] http://www.server101.com Webhosting and E-commerce Solutions Phone : AU (07)38766 101 US 877 7762 101 Fax : +61 7 38763 101 The world is not only stranger than we suppose, it is stranger than we can suppose. -J.B.S. Haldane - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: print database schema
Hello more of a visual tool. The program I did see had views of all the tables as if you had done a describe table_name for each table, then had lines linking the relationships between tables (similar to what you can view in Access , even though i hate to admit I have used it :) would just be good for management and seeing where you can improve indexes etc... thanks. Regards, ___ Steven Wren [EMAIL PROTECTED] http://www.server101.com Webhosting and E-commerce Solutions Phone : AU (07)38766 101 US 877 7762 101 Fax : +61 7 38763 101 The world is not only stranger than we suppose, it is stranger than we can suppose. -J.B.S. Haldane On Tue, 29 Jan 2002, Paul DuBois wrote: At 14:42 +1000 1/29/02, Steven Wren wrote: Hello I was wondering if anyone knew of a program that would allow you to print out a complete database. I have seen it on a PostGre DB, so I am sure MySQL should have something... You mean mysqldump --no-data db_name ? cheers! Regards, ___ Steven Wren [EMAIL PROTECTED] http://www.server101.com Webhosting and E-commerce Solutions Phone : AU (07)38766 101 US 877 7762 101 Fax : +61 7 38763 101 The world is not only stranger than we suppose, it is stranger than we can suppose. -J.B.S. Haldane - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: print database schema
You can run mysqldump from the command line, if you only want the schema you can do: mysqldump -u username databasename -d -p my.dump man mysqldump to see more options. or if you want you can try phpmyadmin at http://www.phpwizard.net/projects/phpMyAdmin/ it is a web based admin tool for mysql. Hope that helps. Thanks, Sherwin Ang Web Programmer / Systems Administrator Alchemy Solutions http://www.alchemy.com.ph Creative. Technology. Tridel Technologies, Inc. 7th Floor Hanston Building Emerald Ave., Ortigas Center Pasig City Tel: (632) 634-5141/ (632) 634-5140 Local 1040 Fax: (632) 634-5139 - Original Message - From: Steven Wren [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 29, 2002 12:42 PM Subject: print database schema Hello I was wondering if anyone knew of a program that would allow you to print out a complete database. I have seen it on a PostGre DB, so I am sure MySQL should have something... cheers! Regards, ___ Steven Wren [EMAIL PROTECTED] http://www.server101.com Webhosting and E-commerce Solutions Phone : AU (07)38766 101 US 877 7762 101 Fax : +61 7 38763 101 The world is not only stranger than we suppose, it is stranger than we can suppose. -J.B.S. Haldane - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php