Unable to import a database in Plesk: UNKNOWN CHARACTER SET: utf8mb4

Follow

Comments

5 comments

  • Avatar
    Jan van Leeuwen

    I would need the DB to be unicode compatible, that is not the case with utf8/utf8_general_ci.

    0
    Comment actions Permalink
  • Avatar
    Bulat Tsydenov

    @Jan van Leeuwen, Hi! If I got you right, the best decision for you would be 'utf8_unicode_ci' collation instead of 'utf8_general_ci'. 

    0
    Comment actions Permalink
  • Avatar
    Jan van Leeuwen

    You are right, I found it after searching for other solutions, thanks anyway, the problem is solved.

    0
    Comment actions Permalink
  • Avatar
    Noam Harel (Edited )

    please write how to upgrade mariaDB in plesk 12.5, i have the same problem but there is no available upgrade

    BTW-  the server says i have mysql 5.5 so this is wierd

    0
    Comment actions Permalink
  • Avatar
    Pavel Mikhaylov (Edited )

    Hello Noam,

    If you wish to substitute MySQL with MariaDB, please refer to this page: https://docs.plesk.com/en-US/12.5/advanced-administration-guide-linux/services-management/database-server.72943/

    Although, doing that, please perform all the actions with caution and do not shy away from backing up data.

    As for the issue with the database, running the command from the second step on the source server (if there is any) should help.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request