# Load missing lesson information in mysql table

**URL:** <https://discuss.openedx.org/t/load-missing-lesson-information-in-mysql-table/10034>\
**Category:** Site Operations Help\
**Tags:** how-to\
**Created:** [May 6, 2023, 9:05pm UTC](https://discuss.openedx.org/t/load-missing-lesson-information-in-mysql-table/10034 "2023-05-06T21:05:04Z")\
**Posts on this page:** 1\
**Showing post:** 11

<div class="post-metadata">

**Author:** ![CourtneyMaybe](https://sea2.discourse-cdn.com/flex020/user_avatar/discuss.openedx.org/courtneymaybe/32/7437_2.png) [@CourtneyMaybe](https://discuss.openedx.org/u/CourtneyMaybe)\
**Post date:** [June 15, 2023, 10:12pm UTC](https://discuss.openedx.org/t/load-missing-lesson-information-in-mysql-table/10034/11 "2023-06-15T22:12:02Z")

</div>

Hey Dave!

We’ve had this instance of OpenEdX for some time. It looks like latin1 was the default encoding for MySQL for the version we are running (5.7).

Do you have any best practices or suggestions for the migration to utf8mb4?

---

_[View the full topic](https://discuss.openedx.org/t/load-missing-lesson-information-in-mysql-table/10034)._