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
