MySQL

For an existing mysql database:

1. Stop MySQL.

On Windows, execute this as an administrator:

net stop mysql

On Unix, execute this as root:

/etc/init.d/owaredb stop

2. Edit MySQL configuration file

On Windows, the configuration file is %SYSTEMROOT%/my.ini.

On Unix, the configuration file is /etc/my.cnf

These are the lines to be added to the [mysqld] section:

default-character-set=utf8

default-collation=utf8_general_ci

character-set-server=utf8

collation-server=utf8_general_ci

init-connect='SET NAMES utf8'

skip-character-set-client-handshake

3. Restart MySql

On Windows, execute this as an administrator:

net start mysql

On Unix, execute this as root:

/etc/init.d/owaredb start

4. Run dbevolve

On windows execute as the install user:

oware dbevolve -x

on unix,

. /etc/.dsienv

dbevolve -x