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

[Gregory Fontenele]

want to leave this list but I can not, can someone erase me from this list?

On Tue, Apr 5, 2011 at 23:08, Mark Shields <laebshade@×××××.com> wrote:

> 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.




-- 
Atenciosamente,
Gregory Fontenele