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

2007-04-27 Thread Daniel da Veiga
On 4/26/07, Michael Sullivan <[EMAIL PROTECTED]> 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 datab

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

2007-04-27 Thread Martin Hudec
Michael Sullivan wrote: /etc/inti.d/mysql stop rsync -av --delete /var/lib/mysql/ newbox01:/var/lib/mysql/ And this method will preserve all granted permissions with their passwords? That would be great! It would. I've been moving mysql the very same way on my bsd boxes. Just stopped the da

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

2007-04-26 Thread kashani
Michael Sullivan wrote: Why bother? User accounts are stored in the db. Just move the whole thing. /etc/inti.d/mysql stop rsync -av --delete /var/lib/mysql/ newbox01:/var/lib/mysql/ And this method will preserve all granted permissions with their passwords? That would be great! Moving the

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

2007-04-26 Thread Michael Sullivan
On Thu, 2007-04-26 at 15:03 -0700, kashani wrote: > Michael Sullivan 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

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

2007-04-26 Thread kashani
Michael Sullivan 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 tro

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

2007-04-26 Thread Michael Sullivan
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. (Mos