Re: [gentoo-user] putting mysql databases from one system to another

[Mark Shields]

On Tue, Apr 5, 2011 at 2:37 PM, <covici@××××××××××.com> wrote:

>
> Josh <korthrun@×××××.com> wrote:
>
> > On Tue, Apr 5, 2011 at 11:59 AM, <covici@××××××××××.com> wrote:
> >
> > > I am trying to copy my databases from one system to another and since
> > > one is 32-bit and the other is 64-bit, I was told that I could not copy
> > > the binary  databases   directly, but I had to  do mysqldump and then
> > > put that source file into the new system.  What I am getting is that
> the
> > > passwords seem not to have gotten through -- the user names seem to be
> > > there, but I cannot login with the passwords the user had in the old
> > > system.
> > >
> > > Can anyone tell me why this is so and what I can do to fix?
> > >
> > > Thanks in advance for any ideas.
> > >
> > > --
> > > Your life is like a penny.  You're going to lose it.  The question is:
> > > How do
> > > you spend it?
> > >
> > >         John Covici
> > >         covici@××××××××××.com
> > >
> > > Which two MySQL versions are in use here?
> >      Older versions of mysql used a different format for the passwords
> and
> > there is a flag you need to pass to mysqld to get it to use old passwords
> (I
> > believe)
> >
> > What is the connection string you are using? Specifically are you
> connecting
> > via the mysql socket, using a hostname etc?
> >      Say the old server was called "foo.stuff.net" and the connection
> was
> > made via the external interface e.g. "mysql -h foo.stuff.net", the user
> may
> > have been setup to allow connections from "foo.stuff.net" only, as where
> now
> > you may be connectin from "bar.stuff.net" or "localhost".
> >
> > SELECT user,host FROM mysql.user ORDER BY user;
> >
> > May shed some light on the situation for you.
> It should be localhost in all cases.  The mysql versions are  5.1.53 in
> both cases.  I am trying to login with the mysql client and I can do it
> on the old box, but not the new one --same host name, etc.
>
> Now I can login with the root password on the new box, maybe that is
> stored somewher else.
>
>
> --
> Your life is like a penny.  You're going to lose it.  The question is:
> How do
> you spend it?
>
>         John Covici
>         covici@××××××××××.com
>
> I hate to ask the obvious, but are you passing "-u <username> and -p" to
mysqldump?  the "-p" by itself will prompt for a password, which you will
then enter. The format should be "mysqldump databasename -u username -p >
file", then enter the password at the "Password:" prompt.