Verify Database Schema - Revision history

Ghillenb at 11:13, 9 February 2016

2016-02-09T11:13:04Z

← Older revision		Revision as of 11:13, 9 February 2016
Line 66:		Line 66:
	* The missing indexes report in ''SiteAdmin->Misc->XMLDB editor->Check Indexes''		* The missing indexes report in ''SiteAdmin->Misc->XMLDB editor->Check Indexes''

	[[de:Datenbank prüfen]]		[[de:Datenbank-Schema prüfen]]
	[[fr:Vérification du schéma de la base de données]]		[[fr:Vérification du schéma de la base de données]]

Ghillenb at 12:59, 17 November 2015

2015-11-17T12:59:27Z

← Older revision		Revision as of 12:59, 17 November 2015
Line 66:		Line 66:
	* The missing indexes report in ''SiteAdmin->Misc->XMLDB editor->Check Indexes''		* The missing indexes report in ''SiteAdmin->Misc->XMLDB editor->Check Indexes''

	[[de:Datenbank~~-Schema~~ prüfen]]		[[de:Datenbank prüfen]]
	[[fr:Vérification du schéma de la base de données]]		[[fr:Vérification du schéma de la base de données]]

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

2013-12-14T15:46:26Z

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

← Older revision		Revision as of 15:46, 14 December 2013
Line 65:		Line 65:

	* The missing indexes report in ''SiteAdmin->Misc->XMLDB editor->Check Indexes''		* The missing indexes report in ''SiteAdmin->Misc->XMLDB editor->Check Indexes''
	* [http://moodle.org/mod/forum/view.php?id=45 Moodle Databases Forum]

	[[de:Datenbank-Schema prüfen]]		[[de:Datenbank-Schema prüfen]]
	[[fr:Vérification du schéma de la base de données]]		[[fr:Vérification du schéma de la base de données]]

Libertymoodle: /* Typo */

2013-05-23T13:11:11Z

Typo

← Older revision		Revision as of 13:11, 23 May 2013
Line 52:		Line 52:
	For example [http://wb.mysql.com/ MySQL Workbench] for MySQL databases.		For example [http://wb.mysql.com/ MySQL Workbench] for MySQL databases.

	This is very useful, if ~~You~~ have a lot of changes.		This is very useful, if you have a lot of changes.

	If you can work a Unix/Linux command line the Python script [http://schemasync.org/ Schema Sync] provides a quick and simple way to generate all the commands to update your database.		If you can work a Unix/Linux command line the Python script [http://schemasync.org/ Schema Sync] provides a quick and simple way to generate all the commands to update your database.

Kofik: Fixed self-introduced typo

2012-07-28T12:28:12Z

Fixed self-introduced typo

← Older revision		Revision as of 12:28, 28 July 2012
Line 16:		Line 16:
	* Generate the database schema from your new site using the following command:		* Generate the database schema from your new site using the following command:
	# MySQL		# MySQL
	mysqldump -no-data -u root -p ''mycleandb'' >clean.schema		mysqldump --no-data -u root -p ''mycleandb'' >clean.schema
	# PostgreSQL		# PostgreSQL
	pg_dump --schema-only -U postgres ''mycleandb'' > clean.schema		pg_dump --schema-only -U postgres ''mycleandb'' > clean.schema

Kofik: Added dump comands for PostgreSQL (8.4 verified) and replace mysqldump's -d by --no-data making it more obvious without reading manpages that it only export the schema without data (not -d like delete) :)

2012-07-28T12:19:16Z

Added dump comands for PostgreSQL (8.4 verified) and replace mysqldump's -d by --no-data making it more obvious without reading manpages that it only export the schema without data (not -d like delete) :)

← Older revision		Revision as of 12:19, 28 July 2012
Line 6:		Line 6:
	* Complete the upgrade		* Complete the upgrade
	* Generate the database schema from your recently upgraded site using the following command:		* Generate the database schema from your recently upgraded site using the following command:
	mysqldump -d -u root -p ''myproductiondb'' >production.schema		# MySQL
			mysqldump --no-data -u root -p ''myproductiondb'' >production.schema
			# PostgreSQL
			pg_dump --schema-only -U postgres ''myproductiondb'' > production.schema
	* Copy the code of your production database to a new (web accessible) location (this is important, it must be the same version)		* Copy the code of your production database to a new (web accessible) location (this is important, it must be the same version)
	* Create a new, empty database and moodledata area for the new site as per the [[Installation]] instructions		* Create a new, empty database and moodledata area for the new site as per the [[Installation]] instructions
Line 12:		Line 15:
	* Run the install script to generate the (if applicable) config.php file and the database (admin and site values are not important)		* Run the install script to generate the (if applicable) config.php file and the database (admin and site values are not important)
	* Generate the database schema from your new site using the following command:		* Generate the database schema from your new site using the following command:
	mysqldump -d -u root -p ''mycleandb'' >clean.schema		# MySQL
			mysqldump -no-data -u root -p ''mycleandb'' >clean.schema
			# PostgreSQL
			pg_dump --schema-only -U postgres ''mycleandb'' > clean.schema
	* Run the following command to detect the differences		* Run the following command to detect the differences
	diff -u production.schema clean.schema >db.diff		diff -u production.schema clean.schema >db.diff

Mina: /* Too many changes to track manually? */ Typo

2012-06-12T15:51:01Z

Too many changes to track manually?: Typo

← Older revision		Revision as of 15:51, 12 June 2012
Line 44:		Line 44:
	You can also use database management programs to synchronize old and new Moodle databases.		You can also use database management programs to synchronize old and new Moodle databases.

	For example [http://wb.mysql.com/ MySQL ~~Workbrench~~] for MySQL databases.		For example [http://wb.mysql.com/ MySQL Workbench] for MySQL databases.

	This is very useful, if You have a lot of changes.		This is very useful, if You have a lot of changes.

Fox: French link

2012-06-06T14:05:28Z

French link

← Older revision		Revision as of 14:05, 6 June 2012
Line 62:		Line 62:

	[[de:Datenbank-Schema prüfen]]		[[de:Datenbank-Schema prüfen]]
			[[fr:Vérification du schéma de la base de données]]

Tsala: Installing Moodle template

2011-11-09T09:58:28Z

Installing Moodle template

← Older revision		Revision as of 09:58, 9 November 2011
Line 1:		Line 1:
			{{Installing Moodle}}
	If you have been upgrading your Moodle site over several versions, it is possible (likely even) that some differences may have crept in between the database table definitions (the "schema") in your database and the version you would get creating a new empty site. This happens because of small errors or oversights in the upgrade scripts. Most of these differences are not harmful, but some may cause strange or unexpected errors. For example, if a default value has been added to a field and this was not reflected in an upgrade script code that assumes the presence of the default may fail to work as expected.		If you have been upgrading your Moodle site over several versions, it is possible (likely even) that some differences may have crept in between the database table definitions (the "schema") in your database and the version you would get creating a new empty site. This happens because of small errors or oversights in the upgrade scripts. Most of these differences are not harmful, but some may cause strange or unexpected errors. For example, if a default value has been added to a field and this was not reflected in an upgrade script code that assumes the presence of the default may fail to work as expected.

Line 57:		Line 58:
	== See also ==		== See also ==

	* The missing indexes report in SiteAdmin->Misc->XMLDB editor->Check Indexes		* The missing indexes report in ''SiteAdmin->Misc->XMLDB editor->Check Indexes''
	* [http://moodle.org/mod/forum/view.php?id=45 Moodle Databases Forum]		* [http://moodle.org/mod/forum/view.php?id=45 Moodle Databases Forum]

	~~[[Category:Administrator]]~~

	[[de:Datenbank-Schema prüfen]]		[[de:Datenbank-Schema prüfen]]

Howardsmiller: /* Too many changes to track manually? */

2011-08-31T12:23:49Z

Too many changes to track manually?

← Older revision		Revision as of 12:23, 31 August 2011
Line 46:		Line 46:

	This is very useful, if You have a lot of changes.		This is very useful, if You have a lot of changes.

			If you can work a Unix/Linux command line the Python script [http://schemasync.org/ Schema Sync] provides a quick and simple way to generate all the commands to update your database.

	==Should I worry?==		==Should I worry?==