Re: [MySql] dumping table structure

[jch341277]

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;