List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:September 20 2010 10:36am
Subject:Re: clone a database on the same machine
View as plain text  
oopss...sorry...i did not see that line....

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

> 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