1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

PMM 7.1 -> 8.0.1 problems

Discussion in 'Plesk for Linux - 8.x and Older' started by mousehouse, Jun 25, 2006.

  1. mousehouse

    mousehouse Guest

    0
     
    Hello Forum,

    For some reason I'm unable to use PMM to migrate a 7.1 server to a new and fresh 8.0.1 machine.

    Using plesk PMM is transferred to the 7.1 server and reports:
    Using this forum I have looked at the "show variables" in MySQL but they look ok (all are latin1 except system which is UTF8).

    Some other thread mentioned installing ART tools, which we cannot do as the 7.1 system is running BSD. The 8.0.1 server is running Debian.

    Any clues?
     
  2. fabianocne

    fabianocne Guest

    0
     
    HI..I have problems with this too

    My name is Fabiano and I am Brazilian. My english is so-so;

    I need help ...

    I have a server with FreeBSD 4.11
    and Plesk 7.1.7 (Server A (67.19.162.2)) and other server with FreeBSD 6.0 Plesk 8.0
    (server B (this)).
    I need to migrate my clientes and domains of server A to
    Server B and I have problems with Plesk Migration Manager. See below.

    Remote agent failed with the following stderr messages: 14:09:55 INFO
    FileFinder: tar resolved to /usr/bin/tar
    14:09:55 INFO New connection: mysql shell connection. db psa, user admin,
    host localhost
    ERROR 1267 (HY000) at line 1: Illegal mix of collations
    (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation
    '='


    This is the Problem.

    How to resolve this?

    Do you Know?


    Wait reply

    thanks

    Fabiano
     
  3. mousehouse

    mousehouse Guest

    0
     
    To say it very nicely, the Plesk PMM on FreeBSD looks a lot like untested software.

    In the end the only way we were able to solve this was:

    1) make a good backup (dump) of the 7.1 machine.

    2) upgrade the 7.1 machine to 7.5.x (even though this broke a lot of things).

    3) upgrade the 7.5.x machine to 8.0 (even though this broke even more things)

    4) used to PMM tools to export on the machine, manually FTP the files to the 8.0 machine and reimport them there.

    Good luck!
     
  4. Bart

    Bart New Pleskian

    22
    57%
    Joined:
    Mar 24, 2008
    Messages:
    17
    Likes Received:
    0
    Better late then never:

    On the old server, make a dump of the psa database, search & replace the word "latin1" (in the charset definitions) with "utf8". Do a restore with the new sql file and launch PMM on the new server again.

    It worked ok for me.

    Best regards,
    Bart
     
  5. Artur

    Artur Guest

    0
     
    Thanks Bart!

    You're the greatest :)
     
  6. Artur

    Artur Guest

    0
     
    looks like all my databases have that same latin1/utf8 problem when dumping through PMM. any ideas on how to make them all compatible in one swoop?
     
Loading...