Page Comparison

...

1. Disconnect all the subscribers and publishers for WSO2 MB 3.2.0.
2. Shut down the server.
3. If you are using an Oracle database, 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 the following command: 
      • On Windows: oracle-mb.sql
      • On 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. Update the

      Open the config.properties file

      with the database parameters for your MB database. You can find the current configurations

      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 that is 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.

...