MySQL - Revision history

Emmarichardson: /* Installing MySQL */

2015-10-20T14:17:52Z

Installing MySQL

← Older revision		Revision as of 14:17, 20 October 2015
Line 4:		Line 4:
	== Installing MySQL ==		== Installing MySQL ==

	* If you are running Linux your preference should be to install using your distributions package manager. This ensures you will get any available updates.		* If you are running Linux your preference should be to install using your distributions package manager. This ensures you will get any available updates. However, you can also use apt-get or yum depending on the distribution that you are running.
	* There are installers available for most popular operating systems at http://www.mysql.com/downloads/mysql/.		* There are installers available for most popular operating systems at http://www.mysql.com/downloads/mysql/.
	* It is possible and reasonably straightforward to build mysql from source but it is not recommended (the pre-built binaries are supposedly better optimised).		* It is possible and reasonably straightforward to build mysql from source but it is not recommended (the pre-built binaries are supposedly better optimised).

Emmarichardson at 14:16, 20 October 2015

2015-10-20T14:16:55Z

← Older revision		Revision as of 14:16, 20 October 2015
Line 41:		Line 41:

	==Which database belongs to which Moodle==		==Which database belongs to which Moodle==
	If you have installed several Moodle installations on the same server, there will be several several databases in your MySQL server. The names might be quite poor reflections of the content like _mdl1 _mdl2 _mdl3 . So how do I see which database goes with which Moodle installation? You can go in with phpMyAdmin and in the various databases check for the table "mdl_course". There you will easily see the name of that Moodle Installation. In table mdl_config you can see the Moodle version. ~~(Where can one find~~ the ~~home relative URL of~~ the ~~Moodle installation?)~~		If you have installed several Moodle installations on the same server, there will be several several databases in your MySQL server. The names might be quite poor reflections of the content like _mdl1 _mdl2 _mdl3 . So how do I see which database goes with which Moodle installation? You can go in with phpMyAdmin and in the various databases check for the table "mdl_course". There you will easily see the name of that Moodle Installation. In table mdl_config you can see the Moodle version. The main URL for the site is not in the database except where there are absolute links.

	== See also ==		== See also ==

Patrickthibaudeau at 15:41, 15 June 2015

2015-06-15T15:41:07Z

← Older revision		Revision as of 15:41, 15 June 2015
Line 9:		Line 9:
	* Make sure you set a password for the 'root' user (see http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html).		* Make sure you set a password for the 'root' user (see http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html).
	* Consider installing and configuring my.cnf (the MySQL settings file) to suit your needs. The default configuration is usually very conservative in respect of memory usage versus performance. Increase the 'max_allowed_packet' setting to at least 4 megabytes.		* Consider installing and configuring my.cnf (the MySQL settings file) to suit your needs. The default configuration is usually very conservative in respect of memory usage versus performance. Increase the 'max_allowed_packet' setting to at least 4 megabytes.
			* If you are going to use Master/Slave replication, you must add binlog_format = 'ROW' into your my.cnf within [mysqld]. Otherwise, Moodle will not be able to write to the database.

	== Creating Moodle database ==		== Creating Moodle database ==

T100ss: /* Creating Moodle database */

2014-12-10T15:34:38Z

Creating Moodle database

← Older revision		Revision as of 15:34, 10 December 2014
Line 15:		Line 15:

	The instructions assume that the web server and MySQL server are on the same machine. In this case the 'dbhost' is 'localhost'. If they are on different machines substitute the name of the web server for 'localhost' in the following instructions and the 'dbhost' setting will be the name of the database server.		The instructions assume that the web server and MySQL server are on the same machine. In this case the 'dbhost' is 'localhost'. If they are on different machines substitute the name of the web server for 'localhost' in the following instructions and the 'dbhost' setting will be the name of the database server.
			Databases have a "Character set" and a "Collation". For moodle the character set should be utf8 and the collation is utf8_general_ci. You may get the option to set these values when you create the database. If you are not given a choice, the default options are probably good. An install on an old server may have the wrong settings.

	=== Command line ===		=== Command line ===

Skodak: /* Installing MySQL */

2014-01-21T07:25:18Z

Installing MySQL

← Older revision		Revision as of 07:25, 21 January 2014
Line 8:		Line 8:
	* It is possible and reasonably straightforward to build mysql from source but it is not recommended (the pre-built binaries are supposedly better optimised).		* It is possible and reasonably straightforward to build mysql from source but it is not recommended (the pre-built binaries are supposedly better optimised).
	* Make sure you set a password for the 'root' user (see http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html).		* Make sure you set a password for the 'root' user (see http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html).
	* Consider installing and configuring my.cnf (the MySQL settings file) to suit your needs. 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. The default configuration is usually very conservative in respect of memory usage versus performance. Increase the 'max_allowed_packet' setting to at least 4 megabytes.

	== Creating Moodle database ==		== Creating Moodle database ==

Germanvaleroelizondo: added link to spanish translation of document

2014-01-05T17:02:06Z

added link to spanish translation of document

← Older revision		Revision as of 17:02, 5 January 2014
Line 52:		Line 52:
	[[ja:MySQL]]		[[ja:MySQL]]
	[[de:MySQL]]		[[de:MySQL]]
			[[es:MySQL]]

Jeffjeff: how to see which SQL database belongs to which Moodle installation

2013-12-29T15:23:14Z

how to see which SQL database belongs to which Moodle installation

← Older revision		Revision as of 15:23, 29 December 2013
Line 37:		Line 37:

	[http://www.phpmyadmin.net/ phpMyAdmin] is a web based administration tool for MySQL. If this is available you can use it to create a new database. Make sure that you select 'UTF8' as the default character set.		[http://www.phpmyadmin.net/ phpMyAdmin] is a web based administration tool for MySQL. If this is available you can use it to create a new database. Make sure that you select 'UTF8' as the default character set.

			==Which database belongs to which Moodle==
			If you have installed several Moodle installations on the same server, there will be several several databases in your MySQL server. The names might be quite poor reflections of the content like _mdl1 _mdl2 _mdl3 . So how do I see which database goes with which Moodle installation? You can go in with phpMyAdmin and in the various databases check for the table "mdl_course". There you will easily see the name of that Moodle Installation. In table mdl_config you can see the Moodle version. (Where can one find the home relative URL of the Moodle installation?)

	== See also ==		== See also ==

Stronk7: Get rid of databases forum link. [https://moodle.org/mod/forum/discuss.php?d=217775]

2013-12-14T15:42:46Z

Get rid of databases forum link. [https://moodle.org/mod/forum/discuss.php?d=217775]

← Older revision		Revision as of 15:42, 14 December 2013
Line 42:		Line 42:
	* [[MariaDB]]		* [[MariaDB]]
	* [http://www.mysql.com/ The MySQL homepage]		* [http://www.mysql.com/ The MySQL homepage]
	* [http://moodle.org/mod/forum/view.php?id=45 Using Moodle databases forum]
	* [http://en.wikipedia.org/wiki/MySQL Wikipedia article about ''MySQL'']		* [http://en.wikipedia.org/wiki/MySQL Wikipedia article about ''MySQL'']
	* [http://forums.mysql.com/read.php?24,92131,92131 List of articles on MySQL performance tuning]		* [http://forums.mysql.com/read.php?24,92131,92131 List of articles on MySQL performance tuning]

Skodak: /* See also */

2013-10-25T19:45:34Z

Dougiamas at 03:14, 16 July 2012

2012-07-16T03:14:18Z

← Older revision		Revision as of 03:14, 16 July 2012
Line 24:		Line 24:
	</pre>		</pre>
	(Enter the password you previously set - or been given - for the MySQL 'root' user). After some pre-amble this should take you to the ''mysql>'' prompt.		(Enter the password you previously set - or been given - for the MySQL 'root' user). After some pre-amble this should take you to the ''mysql>'' prompt.
	* Create a new database (called 'moodle' - substitute your own name if required)		* Create a new database (called 'moodle' - substitute your own name if required). We recommend you use '''utf8_unicode_ci''' for collation.
	<pre>		<pre>
	mysql> CREATE DATABASE moodle DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;		mysql> CREATE DATABASE moodle DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

← Older revision		Revision as of 19:45, 25 October 2013
Line 40:		Line 40:
	== See also ==		== See also ==

			* [[MariaDB]]
	* [http://www.mysql.com/ The MySQL homepage]		* [http://www.mysql.com/ The MySQL homepage]
	* [http://moodle.org/mod/forum/view.php?id=45 Using Moodle databases forum]		* [http://moodle.org/mod/forum/view.php?id=45 Using Moodle databases forum]