On 6/21/06, Xiaobo Chen <xiaobo@stripped> wrote:
> Hi, all
>
> If I use 'mysqldump', I will get the script to create the tables and those
> 'insert' statements to insert the data.
>
> I am wondering if I just want the first part, i.e, the script to create
> the table, is there a command for this end? (I could copy & paste the part
> from 'mysqldump' but it's not what I want to do.)
>
Read the reference manual for the mysqldump program, you can check the
syntax to do that:
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
Specially for the --no-data append.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
