The MySQL database can be downloaded from http://dev.mysql.com/downloads/. Set the root password to mYsql, since this is the default password used by Tricia running in test mode. Additionally we recommend you download the GUI tools from http://dev.mysql.com/downloads/gui-tools/.

The default configuration requires a MySQL database with the name tricia_test locally available under the user account root with password mYsql. You should create this database with the following SQL command:

CREATE DATABASE tricia_test COLLATE utf8_bin;

When importing large databases following error can occur:

MySQL Error Nr.2006-MySQL server has gone away

This can be fixed by increasing the value of the MySQL variable max_allowed_packet (http://bugs.mysql.com/bug.php?id=14236). This is done by inserting the following line in the my.ini file:

[mysqld]

max_allowed_packet=16M

For more information have a look at http://dev.mysql.com/doc/refman/5.1/en/packet-too-large.html.

The main memory consumed by the MySQL database can be increased using the parameter

innodb_buffer_pool_size