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