Sure ... use mysqldump ... it has complete set of options including full
creation/insert.
For example ...
mysqldump -u{username} -p{password} -c --databases foo>foo.sql
... dumps the complete contents, including database/table creation, keys,
and row data to a file called foo.sql
Move foo.sql to another server, and direct it into the mysql client ...
mysql -u{username} -p{password} <foo.sql
Gerald Jensen
----- Original Message -----
From: "Tong Kiat, Chiah" <tongkiat.chiah@stripped>
To: <mysql@stripped>
Sent: Friday, August 03, 2001 5:44 AM
Subject: generate database script from existing table?
Hi
I just took over a mysql database with no documenation. Is there any
tools or anyway I could generate a database/table creation script from
the current database? This is because I need to recreate the database
on another machine and currently I have no way of doing so.
thanks
tk
