------art_27875_125942.1149803816031
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 6/8/06, Chris <csmetcalfe / shaw.ca> wrote:
>
> I've done it once before and cannot find the command to do it.
>
> I'm looking for a SQL command which will spit out the sql statements to
> create an existing database.  All its tables and everything.  So I can
> then take that code and create another database with a different name,
> but which is basically a mirror image of the original, minus the data.


I believe you are looking for the mysqldump command.  It isn't sql but it
outputs the sql to construct a database.  (mysqldump -uer -p
ssword
app_development)

Sean Carley

------art_27875_125942.1149803816031--