| 1 |
On 4/5/2011 11:59 AM, covici@××××××××××.com wrote: |
| 2 |
> I am trying to copy my databases from one system to another and since |
| 3 |
> one is 32-bit and the other is 64-bit, I was told that I could not copy |
| 4 |
> the binary databases directly, but I had to do mysqldump and then |
| 5 |
> put that source file into the new system. What I am getting is that the |
| 6 |
> passwords seem not to have gotten through -- the user names seem to be |
| 7 |
> there, but I cannot login with the passwords the user had in the old |
| 8 |
> system. |
| 9 |
> |
| 10 |
> Can anyone tell me why this is so and what I can do to fix? |
| 11 |
> |
| 12 |
> Thanks in advance for any ideas. |
| 13 |
> |
| 14 |
|
| 15 |
On Linux there is no difference between the on disk format so rsync |
| 16 |
away assuming you're keeping roughly the same Mysql version. You can |
| 17 |
have issues on Windows for some reason. However mysqldump is always |
| 18 |
considered safer for a number of other reasons. |
| 19 |
|
| 20 |
After you imported your fresh new mysqldump you ran flush privileges; |
| 21 |
for the mysql.user table to take effect? |
| 22 |
|
| 23 |
kashani |
Archives