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 > >
