We have migrated and updated our Moodle databases several times over the years, which has resulted in inconsistent database collations. I am by no means a database expert, but I know how to find the answers to the problems at hand. Here are some of the steps that I used to upgrade our moodle site [...]
Mysql Charset and Collation for Moodle
May 31st, 2011
How to view the running/loaded config for MySQL
May 31st, 2011
I had a heck of a time finding out how to see what the parameters were currently loaded for MySQL on our servers. By default, when you install MySQL server from the Ubuntu repositories, the my.cnf config file specifies only a few variables. And the rest just use a default value (my assumption). We recently [...]