i am moving the moodle from win with moodle 3.3.5+ to linux running the same version. i have moved the data and web content and backup the database. as a database on linux i have mariadb 10.2 the issue i am facing as i am not doing a new install what should be the settings for the mariadb .cnf file?
i have the my-huge.cnf but when i see the mysql 5,7 config file it has a lot of different settings.
The short answer is that it probably doesn't mater. Although, make sure you read MySQL_full_unicode_support. That needs to be set up or Moodle will refuse to install.
Once you have it all running and have real users on the system you should tune the database. This is really outside the scope of this forum but there are lots of resources online.
The generic instructions are https://docs.moodle.org/33/en/Moodle_migration.
Also important: https://docs.moodle.org/33/en/Moodle_migration#Update_config.php_with_the_URL_of_the_new_server. Pay special attention to $CFG->dbtype, which will be 'mariadb'.
As Howard has mentioned, if you come across database server parameters, see https://docs.moodle.org/33/en/MySQL_full_unicode_support.
You shouldn't need to mess with the .cnf file unless you are attempting some special configuration - it should work out of the box.
I am never 100% sure about something that I am not running. I really don't get what you are adding to the conservation by linking to my other post. The only thing I can read between the lines is that you are making a judgement about me, based on very little evidence. I find this a strange thing to do on a support forum.
What makes you think it is wrong? Qualify your viewpoint.
That's my experience whenever I've installed Moodle. I have changed my.conf for other software, but not for moodle. Now, why do you disagree with that?
Please read https://docs.moodle.org/33/en/Moodle_migration#Update_config.php_with_the_URL_of_the_new_server, which I've linked already, for more.
The original post was about the mariadb .cnf file, which is a file that manages the database, not moodle. This does not need changing.
what should be the settings for the mariadb .cnf file?
i have the my-huge.cnf but when i see the mysql 5,7 config file it has a lot of different settings.This is a different config file from the one you have referenced.
Like I said at the beginning, the my.conf does not need editing.