Re: clone a database on the same machine

[Johan De Meersman]

On Mon, Sep 20, 2010 at 12:48 PM, Uwe Brauer <oub@stripped> 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