On 4/5/2011 11:59 AM, cov...@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
