Re: [gentoo-user] OT - Migrating databases to a new box

["Daniel da Veiga" <danieldaveiga@gmail.com>]

On 4/26/07, Michael Sullivan <michael@espersunited.com> wrote:
> I'm currently in the process of migrating databases to a new box.  One
> of my users has two databases that he needs access to.  Is there a way
> (through the mysql terminal interface) to find out what passwords he
> uses to access these two databases?  This will save me the trouble of
> finding him.  (Most of my users access remotely).  I have root
> priveleges.  Thank you for your help.
> -Michael Sullivan-
>

First, there's no way to know the passwords, because MySQL uses
one-way encription. Second, if you have SUPER privileges , you can
just dumb the whole server and import this into the new server
(assuming same version and same .conf file). This method causes less
errors (in my tests) but its a lot slower than disk copies...

-- 
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
-- 
gentoo-user@gentoo.org mailing list