Downloads > Database upgrade (prior to 2.0.2)

This is deprecated information for Agilefant versions 2.0.2+

1. Back up your database and previous Agilefant installation

To make sure you can revert to the previous version Agilefant, and for the safety of your data, please take back-ups of your current installation.

First of all, take a database back-up by running the following row in your shell. Later on, you can revert to this database should the upgrade go wrong.

> mysqldump -uDATABASE_USER -pDATABASE_PASS agilefant > dump-agilefant-DATE.sql

Shut down your Tomcat service, and from your Tomcat's webapps directory, copy the .war file and agilefant directory to a safe place. Then, remove both from the webapps directory.

2. Run the sql update scripts

The upgrade scripts can be found inside the Agilefant zip package. The scripts are named according to the version numbers, leaving out the periods. E.g. to upgrade from the 1.6 series to 2.0, run the 160-200.sql.

If you have skipped any versions, please run those scripts also. E.g. When upgrading from Agilefant 2.0 Alpha4 to Agilefant 2.0, run the scripts 200_Alpha4-Alpha5.sql and 200_beta1-beta2.sql.

The upgrading of the database will be simplified in the upcoming releases.