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

[kashani <kashani-list@badapple.net>]

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