• Open Source e-Learning

Breadcrumb Navigation

Updating ILIAS 3.4.0 or 3.4.1 to ILIAS 3.4.3 for MySQL 4.1.x users

These instructions apply only for you if you are currently using MySQL 4.1.x with ILIAS 3.4.0 or ILIAS 3.4.1 and want to update to ILIAS 3.4.3 or higher.
Due to a problem of the UTF-8 handling in these versions it is necessary to dump and reload the entire database. Please make a backup of your database first. Then do the following steps:
  1. Determine your default client character set. Change to your mysql/bin directory, open the mysql shell and check your character settings:

    > mysql -uroot -p ilias3
    mysql> SHOW VARIABLES like '%char%';
    mysql> exit;
  2. Dump the database using this character set (e.g. latin1). The result should be an UTF-8 encoded file. Please note the "--skip-set-charset" attribute which is very important here.

    > mysqldump -uroot -p ilias3 --default-character-set=latin1 --skip-set-charset > ilias3.dump

    (replace latin1 with your default client character set)
  3. Drop and recreate an empty database using an approriate collation, e.g.:

    > mysqladmin -uroot -p drop ilias3
    > mysql -uroot -p
    mysql> CREATE DATABASE ilias3 CHARACTER SET utf8 COLLATE utf8_unicode_ci
  4. Reload the database using UTF-8 as character set:

    > mysql -uroot -p --default-character-set=utf8 ilias3 < ilias3.dump
  5. Now update ILIAS to version 3.4.3 (see section 3 of the general installation instructions) and check whether all content has been migrated properly.
If you have mutiple ILIAS 3.4.0/3.4.1 installations running on one MySQL server you have to update them all at the same time. Do not hesitate to post any questions concerning this procedure in our forum.


No comment has been posted yet.