Utfmb4 instead of utf8mb3? (#442)

regis · June 30, 2021, 4:44am

Yes, I think we should be very happy. Let’s move the conversation here: edX sold to 2U, a SaaS platform - #2 by regis

insad · June 30, 2021, 6:37pm

Some interesting links I found:

https://openedx.atlassian.net/browse/OSPR-5477

https://openedx.atlassian.net/browse/OSPR-5465

https://openedx.atlassian.net/browse/CRI-99

https://openedx.atlassian.net/browse/OSPR-5447

And also

github.com

edx/blockstore/blob/master/blockstore/apps/mysql_unicode/migrations/0001_initial.py

# By default django and many MySQL installations use a broken
# version of unicode ("utf8"). We should always use "utf8mb4"
# which is a correct/non-broken unicode character set, and fully
# supports characters in the supplementary multilingual plane,
# such as emoji, musical notation, mathematical alphanumerics,
# hieroglyphs, cuneiform, rare/historic language symbols
# (sometimes still used in asian family names), and more.
#
# Django has no supported way to change the character set and collation
# so we change it here in a migration.
# By specifying "run_before", we can force this to be the first migration.


from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

This file has been truncated. show original

iamCristYe · July 2, 2021, 4:44am

@regis what do you think?

regis · July 2, 2021, 6:37am

I have a naive question: why is that not desirable?

insad · July 2, 2021, 6:46am

You have a lot of flags you can use with mysqldump, why not put simply a link to the corresponding doc page MySQL :: MySQL 5.7 Reference Manual :: 4.5.4 mysqldump — A Database Backup Program ?

iamCristYe · July 5, 2021, 4:11am

Maybe because they do not actually contains data of openedx? Also not sure when importing the dumped mysql to another db, would dropping mysql database tables be OK, like

DROP TABLE IF EXISTS `db`;
DROP TABLE IF EXISTS `user`;

regis · July 5, 2021, 10:18am

Migrating data to a separate MySQL database is a completely different topic than backing up – which is the topic that is covered in the docs linked above. Let’s stay on topic here; if you’d like to talk about data migration, please create a separate topic.

system · October 3, 2021, 10:19am

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.