![]() ![]() I couldn’t do this via Terminal as I couldn’t find the PHP folder on my Centos + Plesk server to execute the command. $ php admin/cli/mysql_collation.php -collation=utf8mb4_unicode_ci Look for my.cnf file, on Centos this is found in /etc/Īdd the following lines into the file (source: ) If errors occur then come back to manually change the settings here. This is optional as you can skip to running the script and it will make these changes itself. The following steps are the same for MySQL and MariaDB. Update my.cnf file to change configuration settings – Optional Use the local terminal to SSH to your server as root or use an SFTP client to connect to the server. Run the CLI script to convert to the new Character set and Collation in Plesk.Change configuration settings by adding lines to my.cnf (optional).IMPORTANT: Backup your database before making any changes or running the CLI script If this is a production server, put your Moodle in Maintenance mode. You will see the following message under Other checks at the very bottom if your moodle database isn’t upgraded. On Moodle, Go to Site Administration > Server > Environment Use the following steps to change the database Collation if you use a VPS/dedicated server with Centos OS and MariaDB. When starting with a fresh install or upgrading Moodle, you may come across a requirement to change the database Collation from utf8_unicode_ci to utf8mb4_unicode_ci to support four byte characters such as emojis. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |