From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from pigeon.gentoo.org ([208.92.234.80] helo=lists.gentoo.org) by finch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1Q7bXR-0004OR-D0 for garchives@archives.gentoo.org; Wed, 06 Apr 2011 22:49:25 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 44C86E0504; Wed, 6 Apr 2011 22:47:57 +0000 (UTC) Received: from mx.virtyou.com (mx.virtyou.com [94.23.166.77]) by pigeon.gentoo.org (Postfix) with ESMTP id 05606E0504 for ; Wed, 6 Apr 2011 22:47:56 +0000 (UTC) Received: from weird.localnet (xdsl-78-35-153-220.netcologne.de [78.35.153.220]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mx.virtyou.com (Postfix) with ESMTPSA id EAFA73A600D for ; Thu, 7 Apr 2011 00:47:55 +0200 (CEST) From: Alex Schuster To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] putting mysql databases from one system to another Date: Thu, 7 Apr 2011 00:47:53 +0200 User-Agent: KMail/1.13.6 (Linux/2.6.37-ck; KDE/4.6.1; x86_64; ; ) References: <7679.1302029984@ccs.covici.com> <4D9CA2C2.6070107@badapple.net> In-Reply-To: <4D9CA2C2.6070107@badapple.net> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <201104070047.54336.wonko@wonkology.org> X-Archives-Salt: X-Archives-Hash: f831e89f14c4ed0268d7f3065153c83a kashani writes: > On 4/5/2011 11:59 AM, covici@ccs.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? I can't. > On Linux there is no difference between the on disk format so rsync > away assuming you're keeping roughly the same Mysql version. Um, but only when the architecture is identical. I'm pretty sure binary data is stored in different format on 32bit and 64bit systems. Wonko