Installing and upgrading help

moving moodle from win to linux moodle 3.3.5+

 
Picture of timi aliaj
moving moodle from win to linux moodle 3.3.5+
 

Hi Guys,

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.


regards,

Timi

 
Average of ratings: -
Picture of Howard Miller
Re: moving moodle from win to linux moodle 3.3.5+
Core developersDocumentation writersParticularly helpful MoodlersPlugin developers

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. 

 
Average of ratings: -
Picture of Visvanath Ratnaweera
Re: moving moodle from win to linux moodle 3.3.5+
Particularly helpful Moodlers
Hi

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.
 
Average of ratings: -
Retro Drive
Re: moving moodle from win to linux moodle 3.3.5+
 

You shouldn't need to mess with the .cnf file unless you are attempting some special configuration - it should work out of the box. 

 
Average of ratings: -
Picture of Visvanath Ratnaweera
Re: moving moodle from win to linux moodle 3.3.5+
Particularly helpful Moodlers
Are you 100% sure?

Judging from your recent enquiry https://moodle.org/mod/forum/discuss.php?d=370751, I would say the certainty is less than that.
;-X
 
Average of ratings: -
Retro Drive
Re: moving moodle from win to linux moodle 3.3.5+
 

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.

 
Average of ratings: -
Picture of Visvanath Ratnaweera
Re: moving moodle from win to linux moodle 3.3.5+
Particularly helpful Moodlers
If you are not sure then say so!

I am not interested in making judegements on you but on your post: It says the opposite and is wrong!
sad
 
Average of ratings: -
Retro Drive
Re: moving moodle from win to linux moodle 3.3.5+
 

What makes you think it is wrong? Qualify your viewpoint.

 
Average of ratings: -
Picture of Visvanath Ratnaweera
Re: moving moodle from win to linux moodle 3.3.5+
Particularly helpful Moodlers
How about substantiating your statement: "You shouldn't need to mess with the .cnf file unless you are attempting some special configuration - it should work out of the box" related to the original question of this discussion?
 
Average of ratings: -
Retro Drive
Re: moving moodle from win to linux moodle 3.3.5+
 

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?

 
Average of ratings: -
Picture of Visvanath Ratnaweera
Re: moving moodle from win to linux moodle 3.3.5+
Particularly helpful Moodlers
The original poster moves a Moodle site which had MySQL as the database to MariaDB. So $CFG->dbtype has to be changed from 'mysql' (or 'mysqli') to 'mariadb'. Or, do you claim that Moodle will do that by its own?

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.
 
Average of ratings: -
Retro Drive
Re: moving moodle from win to linux moodle 3.3.5+
 

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.
 
Average of ratings: -
Picture of Visvanath Ratnaweera
Re: moving moodle from win to linux moodle 3.3.5+
Particularly helpful Moodlers
IOC, you are talking of the MySQL/MariaDB configuration files. Well then there is this story, https://docs.moodle.org/32/en/Converting_your_MySQL_database_to_UTF8#Converting_a_database_containing_tables.
 
Average of ratings: -
Retro Drive
Re: moving moodle from win to linux moodle 3.3.5+
 

Like I said at the beginning, the my.conf does not need editing.

 
Average of ratings: -