Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: [MySql] dumping table structure

by jch341277 (Sexton)
on Aug 05, 2005 at 20:28 UTC ( [id://481362]=note: print w/replies, xml ) Need Help??


in reply to [MySql] dumping table structure

You can also use:
$ mysqldump -d dbname tablename
The "-d" prevents the client from providing all the row data...

eg:

$ mysqldump -d qosa xlat # MySQL dump 8.12 # # Host: localhost Database: qosa #-------------------------------------------------------- # Server version 3.23.33-log # # Table structure for table 'xlat' # CREATE TABLE xlat ( id int(11) NOT NULL default '0', rexpr text, repla text, PRIMARY KEY (id) ) TYPE=MyISAM;

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://481362]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others having a coffee break in the Monastery: (2)
As of 2024-04-19 19:48 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found