From: Johan De Meersman Date: September 20 2010 11:01am Subject: Re: clone a database on the same machine List-Archive: http://lists.mysql.com/mysql/223047 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0016e642dab412cfe70490aed69c --0016e642dab412cfe70490aed69c Content-Type: text/plain; charset=ISO-8859-1 On Mon, Sep 20, 2010 at 12:48 PM, Uwe Brauer wrote: > >>>>> On Mon, 20 Sep 2010 12:14:06 +0200, Johan De Meersman < > vegivamp@stripped> wrote: > > > He did suggest doing mysqladmin create :-p > > The only thing which is not clear to me is whether > db_org and db_clone > should have the same user (and maybe the same password.) > Databases and users are entirely separate concepts in MySQL. You could grant the same user access to both databases, or you could create a new user that only has access to the clone, however you feel works for you. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --0016e642dab412cfe70490aed69c--