Skip to Main Content

MySQL Database

Best way to convert MySQL 5.7.29 from utf8 to utf8mb4

daniel_haukeFeb 20 2020 — edited Mar 17 2020

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

Comments
Post Details
Added on Feb 20 2020
8 comments
1,977 views