From: x1 <caldridge@...>
Date: 2006-06-09T09:06:20+09:00
Subject: Re: Creating Duplicate MySQL Database

somehting along these lines:

mysqldump -u <user> -p <pass> <database> > backup.sql
mysql -u <user> -p <pass> <new_database> < backup.sql

On 6/8/06, Sean Carley <seanacarley@gmail.com> wrote:
> 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 -u=user -p=password
> app_development)
>
> Sean Carley
>
>