Upgrade MySQL 5.7 to 8 using mysqldump

MySQL & MariaDB
1

Hello Percona & Team,

if we choose msyqldump to upgrade the mysql 5.7 to 8.0.34 it is requried resolve all warnings/error found in upgradechecker utility. do it required to convert object utf8mb3 to utf8mb4 in mysql 5.7 before taking dump using mysqldump.

2

Hi @Pavanmysql ,

“required to resolve all warnings” → No.

  • But you better verify what are those warnings and how it may impact your application. Warnings about config changes, reserve words etc need your attention.

“error” → Yes

“required to convert object utf8mb3 to utf8mb4” → No.

  • But it makes you aware that “utf8” in MySQL 8 means utf8mb4 and not 4. Check the difference between the two here

We do have many upgrade related blogs you might want to refer.

Thanks,
K.

1 Like