Lizard
As Maik says, currently moodle is sql-aware only, so you're going to have to install My SQL. Here are some instructions from our Ops Guide:
This process should take 30 minutes.
Moodle.org and MySQL.org websites recommend setting MySQL using InnoDB for better performance. InnoDB also has transactional logging, which allows changes to be rolled-back.
1. Download the following from the MySQL website (www.mysql.org):
- MySQL full package (not essentials!) for the Windows Installer Package
- MySQL Administrator.
2. Install MySQL
- Install MySQL (typical) from the Windows Installer Package.
- Choose Complete Install, Configure MySQL.
- Skip sign-up.
- Use these settings for the next set of configuration screens:
- detailed configuration,
- server machine,
- multi-functional database,
- set INNODB to c:\MySQL Data files\, (or preferably on a different disk with enough space – database drive)
- OLTP (for heavily loaded connection),
- Remove strict mode tick as this is known to break Moodle,
- Include BIN directory in windows path,
- Execute to start
- Set root password.
- Open the MySQL command prompt, log in and enter the following commands:
CREATE DATABASE moodle DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; <PRESS ENTER>
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,ALTER ON moodle.* TO moodleuser@localhost IDENTIFIED BY 'yourpassword'; <PRESS ENTER>
SET @@global.sql_mode=''; <PRESS ENTER>
Quit <PRESS ENTER>
- Open the Windows command prompt and type:
mysqladmin –u root -p flush-privileges
This will get MySQL database installed. Next install MySQL Administrator which is a front-end to allow you to edit the ini file. Note that these are suggested setting only (you may need to adjust for your system):
3. Install MySQL Admin on the server.
- Install from the download using the install defaults.
4. Tune MySQL as follows.
- Start the MySQL Admin program and enter the server as localhost and the user/pass combination root/password. You should see a screen like this:
- Click Service Control tab -> Configure Service and set the server to use the MAX server by making the settings as follows. Set the InnoDB usage and change the binary to mysqld-max-nt.
- Open Task Manager and find out how much free physical memory you have.
- Now set the startup variables as follows:
- In General Parameters:
- Set the Key_buffer size to 64Mb per 256Mb of free memory (from above)
- Set Default storage to InnoDB.
- Apply changes.
- In InnoDB Parameters,
- Set the Buffer Pool Size as shown on the screen to 80% of available memory:
- In Performance, set the cache size to 4096k to cache query results.
- Click Apply Changes.
- Start and stop the mysql service using the Service Control tab.
That should be it for MySQL.
Let us know how you get on.
Ken