Last updated on March 26, 2015

Appspace Upgrade

Introduction

Prior to upgrading your Appspace server, please:

Ensure all Appspace installation prerequisites have been fulfilled (.NET framework, Visual C++, and SQL database server). Please refer to the Appspace Installation Prerequisites article.
Download the latest version of the Appspace Installation Center.

To perform a full Appspace server upgrade, follow the instructions in the following three sections:

Modifying the MySQL Database
Updating Appspace Installation Center
Upgrading Appspace

Modifying the MySQL Database

If you are upgrading a version of Appspace that is older than 5.1.0 (e.g. any of the 5.0.3.x releases) – perform the following steps to modify the MySQL database to support ANSI quotes.

Note

If you are upgrading a version of Appspace that is 5.1.0 or later, you may skip the Amending the MySQL Database section and proceed to the Updating Appspace Installation Center section below.

Step 1

Start MySQL Workbench.

In Windows 2008, click the Start button and select MySQL Workbench 6.2 CE (in the MySQL folder).

In Windows 2012, click the Windows icon and select MySQL Workbench 6.2 CE from the Apps menu.

Step 2

Once MySQL Workbench has started, select ‘Local instance MySQL56’ and click Connect.

Note

It is highly recommended that you double-check to ensure the MySQL Workbench connection is pointing to the correct my.ini file. If you recently upgraded MySQL Workbench (e.g. from version 5.x to 6.0) there is a chance that Workbench is pointing to an incorrect path. To edit the my.ini reference, right-click the instance and select Edit Connection. Navigate to the System Profile tab and look at the Configuration File field. This path needs to correctly reference the existing my.ini file of the MySQL database server that was originally configured (i.e. C:/Program Files/MySQL Server 5.x/my.ini).

Step 3

When prompted, type the MySQL server password, g56*k9lp, or enter the custom root password created during the original MySQL installation process. Check the ‘Save password in vault’ option for easier access in the future. Click OK to continue.

Step 4

From the Navigator bar on the left, select Options File under INSTANCE (you may have to re-size the upper half of the menu in order to see and click on this selection). This should open up a tab named ‘Administration – Options File’.

Step 5

Click the General tab and scroll down to the ‘SQL’ section.

Step 6

In the ‘sql-mode’ text field, add the following to the existing string (before the closing quotation marks): ,ANSI_QUOTES .

Warning

Be sure to add the comma and do not leave any blank spaces.

Step 7

Click the Networking tab and scroll down to the ‘Timeout Settings’ and ‘Advanced’ sections. Make the following changes:

Check the box for interactive_timeout and give it a value of 30
Check the box for wait_timeout and give it a value of 30
Check the box for max_connect_errors and give it a value of 300
Check the box for max_connections and give it a value of 500

When finished, click the Apply… button to continue.

Step 8

In the ‘Apply Changes to my SQL Configuration File’ window that lists all the configurations that were just made, click the Apply button to confirm the changes.

Step 9

In the Navigator pane on the left, select ‘Startup / Shutdown’ under INSTANCE. ‘The database server instance is’ should read ‘running’. Click the Stop Server button.

Step 10

Wait until you see the ‘The database server instance is’ reads ‘stopped’; this confirms that the MySQL server has shut down. Restart the server at this point by clicking on the Start Server button.