List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:September 20 2010 9:58am
Subject:Re: clone a database on the same machine
View as plain text  
With the method you mentioned, you need to have the new db name already
present.
You can do it this way or the edit dump file way.

regards
anandkl

On Mon, Sep 20, 2010 at 3:19 PM, Johan De Meersman <vegivamp@stripped>wrote:

> Not the way he does it :-)
>
> If you use "--databases", mysqldump will add "create database" and "use
> database" statements. if you specify the db without that parameter, it
> won't.
>
>
> On Mon, Sep 20, 2010 at 11:34 AM, Ananda Kumar <anandkl@stripped> wrote:
>
>> The dump file has to be edited to replace old db name to the new db name.
>>
>> regards
>> anandkl
>>
>> On Mon, Sep 20, 2010 at 3:00 PM, Uwe Brauer <oub@stripped> wrote:
>>
>> > Hello
>> >
>> > I would like to clone a database db_org to db_clone on the same machine.
>> > Could
>> > I use the dump command for this? Should the user of both db
>> > be the same?
>> > Something like
>> > # mysqladmin create db_clone -u DB_user
>> >
>> > mysqldump -p db_org > clone.sql
>> > mysql -p -D db_clone < clone.sql
>> >
>> >
>> > thanks
>> >
>> > Uwe Brauer
>> >
>> >
>> > --
>> > MySQL General Mailing List
>> > For list archives: http://lists.mysql.com/mysql
>> > To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>> >
>> >
>>
>
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>

Thread
clone a database on the same machineUwe Brauer20 Sep
  • Re: clone a database on the same machineAnanda Kumar20 Sep
    • Re: clone a database on the same machineJohan De Meersman20 Sep
      • Re: clone a database on the same machineAnanda Kumar20 Sep
        • Re: clone a database on the same machineJohan De Meersman20 Sep
          • Re: clone a database on the same machineAnanda Kumar20 Sep
  • Re: clone a database on the same machineUwe Brauer20 Sep
    • Re: clone a database on the same machineJohan De Meersman20 Sep
    • Re: clone a database on the same machinea.smith20 Sep