oopss...sorry...i did not see that line.... On Mon, Sep 20, 2010 at 3:44 PM, Johan De Meersman <vegiv...@tuxera.be>wrote:
> 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 >
