I couldn't follow the threading for this one, but you can quickly and easily dump the table structures for all or part of your MySQL databases with mysqldump:
mysqldump --no-data --all-databases This dumps all the database and table creates thusly: -- -- Current Database: test -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ test; USE test; -- -- Table structure for table `DIALUP` -- CREATE TABLE DIALUP ( Full_Name varchar(40) NOT NULL default '', Framed_IP_Address varchar(16) NOT NULL default '' ) TYPE=MyISAM; -- -- Table structure for table `DSL` -- CREATE TABLE DSL ( Full_Name varchar(40) NOT NULL default '', Framed_IP_Address varchar(16) NOT NULL default '' ) TYPE=MyISAM; et cetera. ____________________________________________________________ Eamon Daly ----- Original Message ----- From: "SciBit MySQL Team" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 11, 2004 4:34 PM Subject: RE: Re: [OT] PostgreSQL / MySQL Data Dictionary > > In MySQL, by parsing the output of SHOW CREATE TABLE. > > > > It would be a boon if someone were to write a utility, in an OS-independent > > language, which does that parsing for all tables in a MySQL database and > > returns SQL output that's suitable for creating a set of system tables. > > Obviously bits of this task have already been accomplished by the folks who > > wrote the MySQL module in PHP, for example, and for all we know, much of the > > code for doing it may already exist in phpMyAdmin. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]