Re: [OT] PostgreSQL / MySQL Data Dictionary

[Eamon Daly]

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" <mysql@stripped>
To: <mysql@stripped>
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.