Want to subscribe to topics you're interested in?
Become a Member

Beta Branch update my.cnf base templates in 123.09beta01

Discussion in 'Centmin Mod Github Commits' started by eva2000, Jul 16, 2019.

  1. eva2000

    eva2000 Administrator Staff Member

    41,389
    9,298
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,263
    Local Time:
    11:09 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
  2. pamamolf

    pamamolf Premium Member Premium Member

    3,456
    331
    83
    May 31, 2014
    Ratings:
    +635
    Local Time:
    4:09 PM
    Nginx-1.17.x
    MariaDB 10.3.x
    Invision uses a script to convert to utf8mb and i don't know if that value at the my.cnf cause any issues after or before a conversion .....?

    Scenario 1: I use utf8 the default and convert it using the script to utf8mb4 and then Centminmod adds this parameter... Can that cause an issue?

    Scenario 2: Have in place the charset utf8 by Centminmod and then convert using the Invision script to utf8mb4... Can that cause an issue?

    Thank you !
     
  3. eva2000

    eva2000 Administrator Staff Member

    41,389
    9,298
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +14,263
    Local Time:
    11:09 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    It should if you just leaving Centmin Mod to use utf8 default for MariaDB MySQL as MySQL client auto value previous would be the server default which is utf8 anyway AFAIK.

    Now if you change to utf8mb4 default for MariaDB MySQL instead it would be hard to say whether there would be issues usually they wouldn't for English character based sites. For non-utf8 or non-utf8mb4 sites's data would also be unknown. That's why conversions of such should be only done after full backup is made.