## 3.13. Upgrading from 4.0.2 to 4.1.1

There are no database changes,except for those how upgraded their database to Mysql 5.0.x. Due to changes in the datatype DECIMAL you have to adjust the range of this datatype used in the OLAT database. The alter statements are in the following file. Befor you update uncomment the alter statements in the file and check whether some of your data is affected by the alter statemets.

    mysql -u [olat_db_user] -p < OLAT_HOME/database/alter_4_0_0_to_4_1_0.sql

Install OLAT as described in the installation chapter but DON'T RUN 'ant dbsetup'!! We recommend to move your existing installation from PATH_TO_YOUR_OLAT/olat to PATH_TO_YOUR_OLAT/olat4.0.2 and install the 4.1.1 package as your new PATH_TO_YOUR_OLAT/olat. All user data is located in the olatdata directory which should not be located in the PATH_TO_YOUR_OLAT/olat. The olatdata directory and the database won't be changed when installing the new code.

    #cd PATH_TO_YOUR_OLAT
    #rm olat (if olat is a symlink, otherwise: mv olat olat4.0.2)
    #unzip OLAT-4.1.1.zip
    #ln -s OLAT-4.1.1-FINAL-XXXXX olat
    #cd olat
    #cp build.properties.default build.properties
    #vi build.properties
    #ant config-all
    #ant install

Now start tomcat.