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 & Plesk Backup manager cp1251 problems

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by Ray Lightning, Aug 22, 2011.

  1. Ray Lightning

    Ray Lightning Guest

    0
     
    In Plesk, starting from 8.6 and until 9.5.4 (I didn't tested 10.x yet) the next problem exists:
    All user databases dumps contains symbols "?" instead of russian letters (it's not codepage problems in my browser - there is real "?" signs)

    So, if I have backup of any domain, which database in cp1251 - this backup totally useless.

    The same problem - if I trying to migrate to another server, after migration database on target server again consists of ? instead of russian letters.


    But if I dumping this database - with mysqldump with default parameters - it's OK.

    How can I solve this?

    Plesk 9.5.4. Debian 5.0 (Lenny) 64bit
     
  2. matt-clements

    matt-clements Guest

    0
     
    I presume the Migration wizard is exporting as latin1 or another Charset.

    Could you not migrate all domains over (which will break the DB), then use mysqldump to export an sql file, gzip the file - sftp the file between servers and import the SQL file (fixing the DB issues)?
     
  3. Ray Lightning

    Ray Lightning Guest

    0
     
    I know this, in my case it's uses latin1.
    And I using mysqldump for last 2 years, waiting for solution from Parallels...

    Any comments from Parallels? This bug, at least, a 2 years old...

    All backups of non-utf8 databases are inconsistent....
     
    Last edited by a moderator: Aug 23, 2011
  4. matt-clements

    matt-clements Guest

    0
     
    I agree this should be fixed in a future release - was just offering a way around it for now (which you already are aware of).

    Maybe IgorG or another member of Parallels will comment on this matter?
     
  5. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    Yes, it is known problem with cyrillic symbols and mysql and we have already submitted bugreport for Plesk 10.3.0 version. I hope it will be fixed soon in nearest Plesk update.
     
  6. Ray Lightning

    Ray Lightning Guest

    0
     
    Will this fix available for Plesk 9.x?
     
Loading...