Moodle postgresql create database7/26/2023 Note: Back up all databases before making this change.Note: Back up the configuration file before changing it.On Linux this may be /etc/my.cnf, /etc/mysql/my.cnf, or /etc/my.cnf.d/mariadb-server.cnf on Microsoft Windows it may be my.ini. If your settings do not match any list you will have to edit the MySQL configuration file. If the settings you see match any list above then no changes are needed and you can skip to Creating Moodle database. SHOW GLOBAL VARIABLES WHERE variable_name IN ('innodb_file_format', 'innodb_large_prefix', 'innodb_file_per_table') It is possible to do this after installing your site but is much easier and quicker before installation.Ĭheck if this is already configured by running the following statement, e.g. If this is not done some character sets – notably emojis – cannot be used. It's recommended that full UTF-8 support is configured in MySQL. Otherwise, Moodle will not be able to write to the database. If you are going to use Master/Slave replication, you must add binlog_format = 'ROW' into your my.cnf within.Increase the 'max_allowed_packet' setting to at least 4 megabytes. The default configuration is usually very conservative in respect of memory usage versus performance. Consider installing and configuring my.cnf (the MySQL settings file) to suit your needs.Make sure you set a password for the 'root' user (see ).It is possible and reasonably straightforward to build mysql from source but it is not recommended (the pre-built binaries are supposedly better optimised). There are installers available for most popular operating systems at.However, you can also use apt-get or yum depending on the distribution that you are running. This ensures you will get any available updates. If you are running Linux your preference should be to install using your distribution's package manager.
0 Comments
Leave a Reply. |