I need to migrate that database to a shared hosting server which does not offer full unicode support. I need to keep the utf8mb4 character set because a lot of content with emojis has been used on the site.
On this shared server I can not use Dynamic or Compressed row_format. I can use utf8mb4 with row_format = Compact, but moodle has many tables with indexes that use key columns with sizes above 191 characters, therefore, I can not import the database from an .sql file unless I change the size of those keys.
I edited the dumped .sql file and resized the keys from 255 and 200 characters to 191 characters, so I was able to restore the database on the new server with collation = utf8mb4_unicode_ci and row_format = Compact (Antelope).
I did a test installation of the site and it works perfect, but I'm not sure if I can use it on production site.
I ask: Can I use that database with the changes in the size of the index keys?. Will I have problems installing new updates or plugins?
Thanks in advance
Greetings from Venezuela