MySQL - Revision history

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;

Tsala: copying recent changes from 21 wiki

2011-12-20T10:21:57Z

copying recent changes from 21 wiki

← Older revision		Revision as of 10:21, 20 December 2011
Line 1:		Line 1:
	{{Installing Moodle}}		{{Installing Moodle}}
	MySQL is one of the supported databases that underpins a Moodle installation.		MySQL is one of the supported databases that underpins a Moodle installation.

	MySQL describes itself as "the most popular Open Source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers. It is a second generation Open Source company that unites Open Source values and methodology with a successful business model."

	MySQL comes with an array of [http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html storage engines]. The popular ones being MyISAM and InnoDB. Since MySQL 5.5.5, MyISAM was dropped as default and InnoDB was made the [http://dev.mysql.com/doc/refman/5.5/en/innodb-default-se.html default storage engine] of choice. InnoDB is more well supportable than MyISAM due to known issues with MyISAM. MyISAM and non-ACID master-master setups can have issues which sometimes prove difficult to support.

	== Installing MySQL ==		== Installing MySQL ==
Line 11:		Line 7:
	* 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).
	* Make sure you set a password for the 'root' user.		* 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.

	== Creating Moodle database ==		== Creating Moodle database ==
Line 46:		Line 43:
	* [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]
	* [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]

	[[Category:SQL databases]]		[[Category:SQL databases]]

Tsala: copying recent changes from 21 wiki

2011-12-08T10:03:32Z

copying recent changes from 21 wiki

@@ Line 1: / Line 1: @@
 MySQL is one of the supported databases that underpins a Moodle installation.
@@ Line 4: / Line 5: @@
 MySQL comes with an array of [http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html storage engines]. The popular ones being MyISAM and InnoDB. Since MySQL 5.5.5, MyISAM was dropped as default and InnoDB was made the [http://dev.mysql.com/doc/refman/5.5/en/innodb-default-se.html default storage engine] of choice. InnoDB is more well supportable than MyISAM due to known issues with MyISAM.  MyISAM and non-ACID master-master setups can have issues which sometimes prove difficult to support.
 == See also ==
@@ Line 10: / Line 47: @@
 * [http://en.wikipedia.org/wiki/MySQL Wikipedia article about ''MySQL'']
 [[Category:SQL databases]]
 [[ja:MySQL]]
 [[de:MySQL]]

Aparup at 06:43, 11 August 2011

2011-08-11T06:43:29Z

← Older revision		Revision as of 06:43, 11 August 2011
Line 3:		Line 3:
	MySQL describes itself as "the most popular Open Source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers. It is a second generation Open Source company that unites Open Source values and methodology with a successful business model."		MySQL describes itself as "the most popular Open Source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers. It is a second generation Open Source company that unites Open Source values and methodology with a successful business model."

	MySQL comes with an array of [http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html storage engines]. The popular ones being MyISAM and InnoDB. Since MySQL 5.5.5, MyISAM was dropped as default and InnoDB was made the [http://dev.mysql.com/doc/refman/5.5/en/innodb-default-se.html default storage engine] of choice. InnoDB is more well supportable than MyISAM due to known issues with MyISAM. MyISAM and non-ACID master-master setups can have issues which ~~can~~ sometimes prove difficult to support.		MySQL comes with an array of [http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html storage engines]. The popular ones being MyISAM and InnoDB. Since MySQL 5.5.5, MyISAM was dropped as default and InnoDB was made the [http://dev.mysql.com/doc/refman/5.5/en/innodb-default-se.html default storage engine] of choice. InnoDB is more well supportable than MyISAM due to known issues with MyISAM. MyISAM and non-ACID master-master setups can have issues which sometimes prove difficult to support.
	== See also ==		== See also ==

Aparup at 06:42, 11 August 2011

2011-08-11T06:42:21Z

← Older revision		Revision as of 06:42, 11 August 2011
Line 3:		Line 3:
	MySQL describes itself as "the most popular Open Source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers. It is a second generation Open Source company that unites Open Source values and methodology with a successful business model."		MySQL describes itself as "the most popular Open Source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers. It is a second generation Open Source company that unites Open Source values and methodology with a successful business model."

	MySQL comes with an array of [http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html storage engines]. The popular ones being MyISAM and InnoDB. Since MySQL 5.5.5, MyISAM was dropped as default and InnoDB was made the [http://dev.mysql.com/doc/refman/5.5/en/innodb-default-se.html default storage engine] of choice. InnoDB is more well supportable than MyISAM due to known issues with MyISAM.		MySQL comes with an array of [http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html storage engines]. The popular ones being MyISAM and InnoDB. Since MySQL 5.5.5, MyISAM was dropped as default and InnoDB was made the [http://dev.mysql.com/doc/refman/5.5/en/innodb-default-se.html default storage engine] of choice. InnoDB is more well supportable than MyISAM due to known issues with MyISAM. MyISAM and non-ACID master-master setups can have issues which can sometimes prove difficult to support.
	== See also ==		== See also ==

Aparup at 05:13, 11 August 2011

2011-08-11T05:13:42Z

← Older revision		Revision as of 05:13, 11 August 2011
Line 3:		Line 3:
	MySQL describes itself as "the most popular Open Source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers. It is a second generation Open Source company that unites Open Source values and methodology with a successful business model."		MySQL describes itself as "the most popular Open Source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers. It is a second generation Open Source company that unites Open Source values and methodology with a successful business model."

	MySQL comes with an array of [http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html storage engines]. The popular ones being MyISAM and InnoDB. Since MySQL 5.5.5, InnoDB is the [http://dev.mysql.com/doc/refman/5.5/en/innodb-default-se.html default storage engine] of choice. InnoDB is more well supportable than MyISAM due to known issues with MyISAM.		MySQL comes with an array of [http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html storage engines]. The popular ones being MyISAM and InnoDB. Since MySQL 5.5.5, MyISAM was dropped as default and InnoDB was made the [http://dev.mysql.com/doc/refman/5.5/en/innodb-default-se.html default storage engine] of choice. InnoDB is more well supportable than MyISAM due to known issues with MyISAM.
	== See also ==		== See also ==

Aparup at 04:16, 11 August 2011

2011-08-11T04:16:25Z

← Older revision		Revision as of 04:16, 11 August 2011
Line 3:		Line 3:
	MySQL describes itself as "the most popular Open Source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers. It is a second generation Open Source company that unites Open Source values and methodology with a successful business model."		MySQL describes itself as "the most popular Open Source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers. It is a second generation Open Source company that unites Open Source values and methodology with a successful business model."

			MySQL comes with an array of [http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html storage engines]. The popular ones being MyISAM and InnoDB. Since MySQL 5.5.5, InnoDB is the [http://dev.mysql.com/doc/refman/5.5/en/innodb-default-se.html default storage engine] of choice. InnoDB is more well supportable than MyISAM due to known issues with MyISAM.
	== See also ==		== See also ==

Ghillenb at 13:23, 16 March 2009

2009-03-16T13:23:21Z

← Older revision		Revision as of 13:23, 16 March 2009
Line 14:		Line 14:

	[[ja:MySQL]]		[[ja:MySQL]]
			[[de:MySQL]]

Tsala: stub template removed

2007-11-28T21:12:24Z

stub template removed

← Older revision		Revision as of 21:12, 28 November 2007
Line 2:		Line 2:

	MySQL describes itself as "the most popular Open Source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers. It is a second generation Open Source company that unites Open Source values and methodology with a successful business model."		MySQL describes itself as "the most popular Open Source SQL database management system, is developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company, founded by the MySQL developers. It is a second generation Open Source company that unites Open Source values and methodology with a successful business model."


	== See also ==		== See also ==
Line 9:		Line 8:
	* [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]
	* [http://en.wikipedia.org/wiki/MySQL Wikipedia article about ''MySQL'']		* [http://en.wikipedia.org/wiki/MySQL Wikipedia article about ''MySQL'']


	[[Category:Administrator]]		[[Category:Administrator]]
	[[Category:Developer]]		[[Category:Developer]]
	[[Category:SQL databases]]		[[Category:SQL databases]]


	~~{{stub}}~~

	[[ja:MySQL]]		[[ja:MySQL]]

Mits: ja link

2007-05-24T15:46:06Z

ja link

← Older revision		Revision as of 15:46, 24 May 2007
Line 17:		Line 17:

	{{stub}}		{{stub}}

			[[ja:MySQL]]