From: Mogens Melander
Date: July 23 2007 4:29pm
Subject: Re: Seeing Table Structure
List-Archive: http://lists.mysql.com/mysql/208181
Message-Id: <4717.90.184.16.67.1185208181.squirrel@mail.fumlersoft.dk>
MIME-Version: 1.0
Content-Type: text/plain;charset=utf-8
Content-Transfer-Encoding: 8bit

Try this:

# mysqldump -d DBNAME > tables.sql

--no-data, -d

  Do not write any row information for the table.
  This is very useful if you want to dump only
  the CREATE TABLE statement for the table.

On Mon, July 23, 2007 18:22, Olaf Stein wrote:
> I don't know of any way of doing this for all tables.
> I wrote a python script that creates a html file with information about
> tables (engine, fields,keys,indices)
>
> If you are interested in it I can email it
>
> Olaf
>
> On 7/23/07 11:34 AM, "tonylabarbara@stripped" <tonylabarbara@stripped> wrote:
>
>> Hi;
>> I need to see the table structure of all the tables of a database I have. I
>> could also just dump all the data from all the tables in the database and copy
>> the database, thus grabbing the table structures. I can´t find in the
>> documentation how to do either of those. Please advise.
>> TIA,
>> Tony
>> ________________________________________________________________________
>> AOL now offers free email to everyone.  Find out more about what's free from
>> AOL at AOL.com.
>
>
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=mogens@stripped
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>


-- 
Later

Mogens Melander
+45 40 85 71 38
+66 870 133 224



-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.