MySql - Creating Prepopulated Table

[juicytuna]

I have a table with over 100 rows which I'd like to be able to recreate on other servers. Using create_table and manually entering each row as an argument will take a long time as you can imagine. Is there a quick way for generating a prepopulated create_table statement for on an already existing table?

Thanks.

[phranque]

the CREATE TABLE statement does not have a syntax for inserting rows into the table.
if you want to duplicate an existing table from one database in another database i would suggest using mysqldump:

first:
mysqldump -uuser -ppassword olddatabase table >olddatabase_table.sql
(where user, password, olddatabase and table are replaced with actual names/values)
olddatabase_table.sql will contain among other statements a suitable CREATE TABLE statement and a series of INSERT statements to reproduce the existing table with its contents.
then:
mysql -uuser -ppassword newdatabase <olddatabase_table.sql