Database FAQ
From MoodleDocs
Note: This article is a work in progress. Please use the page comments or an appropriate moodle.org forum for any recommendations/suggestions for improvement.
Databases and Moodle
When talking about Moodle and databases there are actually two different kind of things which can be meant:
- the Moodle activity named Database
- the database on your server where Moodle stores all its content
Database module (activity)
See
Moodle database
- Development:Database Schema - The files available here are in DBDesigner4 format. DBDesigner4 is a schema drawing program released under GPL.
- Development:Database schema introduction
- Create Moodle site database
- "Database abstraction layers and Moodle" from Christopher Douce's blog (Open University)
XMLDB
XMLDB stores the database definition in an XML format that can be used to install Moodle on any database.
Different kinds of databases
- MySQL
- MSSQL, see Installing MSSQL for PHP
- Oracle, see Installing Oracle for PHP
- PostgreSQL