I recently added a new collation to MySQL as outlined here for the purpose of including a dash
- character in fulltext searches. It worked fine but a couple of days later my changes were overwritten by the apt.systemd.daily Unattended-Upgrade routine (which btw, I had no idea existed).
My question: Is there an upgrade-proof way to modify MySQL collation / charsets? I understand some system files are not meant to be altered, but typically there would be an appropriate user configuration file where those changes can be applied. Since I followed the official guidelines, I am surprised that these are files which would be replaced by an automatic system process.
UPDATE: Just to be 100% clear I'm talking about edits made to the following two files (which are referenced in the article I linked above):