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

    daniel_hauke

      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.

       

      Greetings,

      Daniel