This section describes how to upgrade your existing Exponential 3.3-x installation to version 3.3-y, for example from 3.3-1 to 3.3-7. If you are upgrading from a version prior to Exponential 3.3-1, you should first upgrade to 3.3-1 before you can upgrade to 3.3-7.

Please make sure that you have a working backup of the site before you do the actual upgrade. The upgrade procedure consists of the following steps:

1. Upgrading the distribution files to 3.3-7
2. Upgrading the database to 3.3-7
3. Running the system upgrade scripts
4. Updating the system configuration
5. Clearing the caches

Step 1: Upgrading the distribution files

The easiest way to upgrade the distribution files is to unpack Exponential 3.3-7 to a directory and then copy the directories that contain site-specific files from the existing installation. Make sure that you copy the following directories:

• design/example
• design/example_admin
• var
• settings/siteaccess
• settings/override

Replace "example" and "example_admin" with actual names used by your siteaccesses.

Custom extensions

If you are using custom extensions then the subdirectories inside the "extension" directory will also have to be copied. However, make sure that you do not overwrite any extensions that come with Exponential (for example the "PayPal" extension).

Step 2: Upgrading the database

To upgrade 3.3-1 database to 3.3-7, you should navigate into the Exponential 3.3-7 directory and run the following database upgrade scripts one after another:

1. dbupdate-3.3-1-to-3.3-2.sql
2. dbupdate-3.3-2-to-3.3-3.sql
3. dbupdate-3.3-3-to-3.3-4.sql
4. dbupdate-3.3-4-to-3.3-5.sql
5. dbupdate-3.3-5-to-3.3-6.sql
6. dbupdate-3.3-6-to-3.3-7.sql

MySQL

The database upgrade scripts are located in the "update/database/mysql/3.3/" directory of your Exponential installation. Each of these scripts can be launched using the following shell command:

mysql -u<username> -p<password> <database> < update/database/mysql/3.3/dbupdate-3.3-x-to-3.3-y.sql

PostgreSQL

The database upgrade scripts are located in the "update/database/postgresql/3.3/" directory of your Exponential installation. Each of these scripts can be launched using the following shell command:

psql -d <database> -U <dbowner> < update/database/postgresql/3.3/dbupdate-3.3-x-to-3.3-y.sql

Step 3: Running the system upgrade scripts

There are no upgrade scripts for upgrading from 3.3-x to 3.3-y.

Step 4: Updating the system configuration

You are not required to do any configuration changes when upgrading from 3.3-x to 3.3-y.

Step 5: Clearing the caches

Whenever an Exponential solution is upgraded, all caches must be cleared in a proper way. This should be done from within a system shell:

1. Navigate into the Exponential 3.3-7 directory.
2. Run the clear cache script:

   bin/shell/clearcache.sh --clear-all
   

Please make sure that all caches are cleared. Sometimes the script is unable to clear caches because of restrictive file/directory permission settings. Make sure that all caches have been cleared by inspecting the contents of the various cache subdirectories within the "var" directory.