# Upgrade MySQL 5.7 to 8 using mysqldump

**URL:** <https://forums.percona.com/t/upgrade-mysql-5-7-to-8-using-mysqldump/25793>\
**Category:** MySQL & MariaDB\
**Tags:** mysql\
**Created:** [October 10, 2023, 5:19am UTC](https://forums.percona.com/t/upgrade-mysql-5-7-to-8-using-mysqldump/25793 "2023-10-10T05:19:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pavanmysql](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavanmysql/32/7152_2.png) [@Pavanmysql](https://forums.percona.com/u/Pavanmysql)\
**Post date:** [October 10, 2023, 5:19am UTC](https://forums.percona.com/t/upgrade-mysql-5-7-to-8-using-mysqldump/25793/1 "2023-10-10T05:19:36Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\
**Post date:** [October 10, 2023, 5:38am UTC](https://forums.percona.com/t/upgrade-mysql-5-7-to-8-using-mysqldump/25793/2 "2023-10-10T05:38:34Z")

</div>

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](https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html)

We do have many [upgrade related blogs](https://www.percona.com/search?search=upgrade%20mysql%208) you might want to refer.

Thanks,  
K.