Page Comparison

The instructions on this page take you through the steps for upgrading from MB 3.1.0 to MB 3.2.0. Note that you cannot rollback the upgrade process. However, it is possible to restore a backup of the previous database and restart the upgrade progress.

...

1. Disconnect all the subscribers and publishers for WSO2 MB 3.2.0.
2. Shut down the server.
3. Run the migration script to update the database:
   1. Open a terminal and navigate to the <MB_HOME>/dbscripts/mb-store/migration-3.1.0_to_3.2.0 directory.
   2. Execute Run the migration script relevant to your database type. For example, if you are using an Oracle, use the following commandOn Windows: script: oracle-mb.sqlOn Linux: sh oracle-mb.sql 
4. Download and run the migration tool:
   

   1. Download the migration tool.

   2. Unzip the org.wso2.mb.migration.tool.zip file. The directory structure of the unzipped folder is as follows:

      Panel
      TOOL_HOME |-- lib <folder> |-- config.properties <file> |-- tool.sh <file> |-- README.txt <file> |-- org.wso2.carbon.mb.migration.tool.jar

   3. Download the relevant database connector and copy it to the lib directory in the above folder structure. For example, if you are upgrading your MySQL databases, you can download the MySQL connector JAR from http://dev.mysql.com/downloads/connector/j/5.1.html and copy it to the lib directory.

   4. Open the config.properties file from the org.wso2.mb.migration.tool.zip file that you downloaded in step 4 above and update the database connection details shown below. 
      

      Code Block
      #Configurations for the database dburl= driverclassname= dbuser= dbpassword=

      The parameter in the above file are as follows:

      • dburl: The URL for the database. For example, jdbc:mysql://localhost/wso2_mb
      • driverclassname:The database driver class. For example, com.mysql.jdbc.Driver for MySQL.
      • dbuser: The user name for connecting to the database.
      • dbpassword: The password for connecting to the database.
   5. Update the datasource connection for the MB database in the master-datasources.xml file (stored in the <MB_HOME_320>/repository/conf/datasources directory).

   6. Run the migration tool:

      1. If you are on a Linux environment, open a command prompt and execute the following command: tool.sh.

      2. If you are on a non-Linux environment, execute org.wso2.carbon.mb.migration.tool.jar manually.
5. Start WSO2 MB 3.2.0.
6. Reconnect all the publishers and subscribers to MB 3.2.0.

...