8 Replies Latest reply on Mar 17, 2020 7:14 AM by daniel_hauke

    Best way to convert MySQL 5.7.29 from utf8 to utf8mb4


      Hi everybody,


      we are struggeling with problems on our MySQL Database (5.7.29, Commercial Edition) with the configured default character-set utf8 so we have to convert this database so that it uses utf8mb4 as default characterset.


      What is the preferred way to do this?

      I think creating a new MySQL Database with the new default characterset utf8mb4 and then doing an export / import of the data is better then executing a bunch of sql statements which are altering the structure of the database, tables and so on.


      Has anybody done this before?


      Any help would be appreciated.