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;
|
|---|