Database utf8mb4 collation

Anyone who has had their database switched from utf8mb4 utf8mb4_unicode_ci to something else, or on backup incorrect collation on restore, has found themselves with things not working properly.

This simple php script will fix your problems, and I wrote it real quick when I had a database issue.

It must go in your site root. Then access it by

https://mysite/convert_mysql.php

It will take a minute, then be done. So much easier than any other method you may have googled 😁

Remove the script when done.

Enjoy!

Note: you may need to rename the downloaded php file from the abcdefghijkl.php to convert_mysql.php (due to UNA S3 storage).