From: Johan De Meersman Date: September 20 2010 10:14am Subject: Re: clone a database on the same machine List-Archive: http://lists.mysql.com/mysql/223044 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0050450156882e4d7a0490ae2cd3 --0050450156882e4d7a0490ae2cd3 Content-Type: text/plain; charset=ISO-8859-1 He did suggest doing mysqladmin create :-p On Mon, Sep 20, 2010 at 11:58 AM, Ananda Kumar 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 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 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 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=anandkl@stripped >>> > >>> > >>> >> >> >> >> -- >> 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 --0050450156882e4d7a0490ae2cd3--