Gentoo Archives: gentoo-user

From: Alex Schuster <wonko@×××××××××.org>
To: gentoo-user@l.g.o
Subject: Re: [gentoo-user] putting mysql databases from one system to another
Date: Wed, 06 Apr 2011 22:49:25
Message-Id: 201104070047.54336.wonko@wonkology.org
In Reply to: Re: [gentoo-user] putting mysql databases from one system to another by kashani
1 kashani writes:
2
3 > On 4/5/2011 11:59 AM, covici@××××××××××.com wrote:
4 > > I am trying to copy my databases from one system to another and since
5 > > one is 32-bit and the other is 64-bit, I was told that I could not copy
6 > > the binary databases directly, but I had to do mysqldump and then
7 > > put that source file into the new system. What I am getting is that
8 > > the passwords seem not to have gotten through -- the user names seem
9 > > to be there, but I cannot login with the passwords the user had in the
10 > > old system.
11 > >
12 > > Can anyone tell me why this is so and what I can do to fix?
13
14 I can't.
15
16 > On Linux there is no difference between the on disk format so rsync
17 > away assuming you're keeping roughly the same Mysql version.
18
19 Um, but only when the architecture is identical. I'm pretty sure binary data
20 is stored in different format on 32bit and 64bit systems.
21
22 Wonko

Replies

Subject Author
Re: [gentoo-user] putting mysql databases from one system to another kashani <kashani-list@××××××××.net>