The external database requires a server that runs MySQL.
See information at http://www.mysql.com/ how to install MySQL. The database is tested with MySQL version 5.0 but is likely to work also with later versions.
Open the Ecolego installation directory, and open the folder lib\database. There you will find a MySQL backup file with name “ecolegodb.sql”.
This file should be run with the MySQL Administrator tool. From the MySQL Administrator tool the file can be loaded as shown below:
After the database is installed, the proper users and their access privileges have to be setup. This can also be done with the MySQL administrator tool, as shown below.
If another user should have only read privileges to the Ecolego database, only the item SELECT should be added to the “Assigned Privileges”.
When the database is set up, you must set the database preferences, as described in Connecting to an external database.