He did suggest doing mysqladmin create :-p On Mon, Sep 20, 2010 at 11:58 AM, Ananda Kumar <anan...@gmail.com> 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 <vegiv...@tuxera.be>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 <anan...@gmail.com> 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 <o...@mat.ucm.es> 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=anan...@gmail.com >>> > >>> > >>> >> >> >> >> -- >> 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
