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 <gentoo-user+bounces-121364-garchives=archives.gentoo.org@lists.gentoo.org>)
	id 1Q7WYX-0005Me-44
	for garchives@archives.gentoo.org; Wed, 06 Apr 2011 17:30:13 +0000
Received: from pigeon.gentoo.org (localhost [127.0.0.1])
	by pigeon.gentoo.org (Postfix) with SMTP id B0F691C00B;
	Wed,  6 Apr 2011 17:28:31 +0000 (UTC)
Received: from www01.badapple.net (www01.badapple.net [64.79.219.163])
	by pigeon.gentoo.org (Postfix) with ESMTP id 8CEB51C00B
	for <gentoo-user@lists.gentoo.org>; Wed,  6 Apr 2011 17:28:31 +0000 (UTC)
Received: from [127.0.0.1] (173-8-169-73-SFBA.hfc.comcastbusiness.net [173.8.169.73])
	(Authenticated sender: ramin@badapple.net)
	by www01.badapple.net (Postfix) with ESMTPSA id 9F2EA9FAFBCA
	for <gentoo-user@lists.gentoo.org>; Wed,  6 Apr 2011 10:28:30 -0700 (PDT)
Message-ID: <4D9CA2C2.6070107@badapple.net>
Date: Wed, 06 Apr 2011 10:28:34 -0700
From: kashani <kashani-list@badapple.net>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.15) Gecko/20110303 Thunderbird/3.1.9
Precedence: bulk
List-Post: <mailto:gentoo-user@lists.gentoo.org>
List-Help: <mailto:gentoo-user+help@lists.gentoo.org>
List-Unsubscribe: <mailto:gentoo-user+unsubscribe@lists.gentoo.org>
List-Subscribe: <mailto:gentoo-user+subscribe@lists.gentoo.org>
List-Id: Gentoo Linux mail <gentoo-user.gentoo.org>
X-BeenThere: gentoo-user@lists.gentoo.org
Reply-to: gentoo-user@lists.gentoo.org
MIME-Version: 1.0
To: gentoo-user@lists.gentoo.org
Subject: Re: [gentoo-user] putting  mysql databases from one system to another
References: <7679.1302029984@ccs.covici.com>
In-Reply-To: <7679.1302029984@ccs.covici.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Archives-Salt: 
X-Archives-Hash: ce55ddcf5d9720fa3ecfb81f8b732b32

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?
>
> Thanks in advance for any ideas.
>

	On Linux there is no difference between the on disk format so rsync 
away assuming you're keeping roughly the same Mysql version. You can 
have issues on Windows for some reason. However mysqldump is always 
considered safer for a number of other reasons.

	After you imported your fresh new mysqldump you ran flush privileges; 
for the mysql.user table to take effect?

kashani