Re: Just need script for creating tables

2006-06-21 Thread Martin Jespersen
--no-data should do the trick, try to do mysqldump --help and read the output Xiaobo Chen 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 t

RE: Just need script for creating tables

2006-06-21 Thread Peter Lauri
You can do something like: mysqldump --no-data -Original Message- From: Xiaobo Chen [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 21, 2006 9:11 PM To: mysql@lists.mysql.com Subject: Just need script for creating tables Hi, all If I use 'mysqldump', I will get the script to create t

Re: Just need script for creating tables

2006-06-21 Thread Daniel da Veiga
On 6/21/06, Xiaobo Chen <[EMAIL PROTECTED]> 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 co