List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:September 20 2010 10:14am
Subject:Re: clone a database on the same machine
View as plain text  
He did suggest doing mysqladmin create :-p

On Mon, Sep 20, 2010 at 11:58 AM, Ananda Kumar <anandkl@stripped> wrote:

> 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
>>
>
>


-- 
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