Run Upgrade Utility on Linux

Steps to Run Upgrade Utility on Linux

• Navigate to the scripts directory

apache-tomcat-dbsync/scripts

As shown below

Once inside the directory run

./upgrade-cli.sh

After running the above command you will get the following message and will show the latest version available

Type Y if you want to upgrade

Once Y is entered it will take a backup of all your files and folders from the previous version

And will create a backup folder

Once the process is completed you can check if your tomcat is running or not if not rerun and log in to dbsync There you can find all your profile and configurations done on the older version

Manual Backup

If the backup is not created and you see your folders/files missing use the below steps for manual backup. Do this only if you want to Upgrade Manually or If the script fails to upgrade

Moving files from one directory to another Command:

# mv source directory/* destination directory/

Copying from one dir to another

Command :

# Cp -r source directory /~/ destination directory 

To check if your tomcat is running or not

# ps -ef | grep java

• Step: To check the logs you can run the command tail -f Catalina. out as illustrated in the screenshot below

# cd /home/dbsync/apache-tomcat-9.0.33/logs

# ls -l

Now Tail the logs

# tail -f catalina.out

The above screenshot shows that the tomcat was running

Step: To access the DBSync Cloud Replication console, please paste the http://< IP >:8080/dbsync

Use the http://localhost:8080/dbsync URL in your browser address bar, and you will be presented with the DBSync Cloud Replication Home page.

Take a backup of profiles

• Create a backup directory in the home folder

• mkdir <folder name>

• Go to the following directory /home/dbsync/dbsync/dbsync-cdm/WEB-INF/profiles/1

• Use the below command to copy the files present inside the profiles folder

• cp -r <install-dir>/dbsync-cdm/WEB-INF/profiles ~/<destination folder>/

Take a backup of Scheduler jobs

• Create a backup directory in the home folder

• mkdir <folder name>

• Go to the following directory dbsync/scheduler

• Use the below command to copy the files present inside the scheduler folder

• cp -r <install-dir>/scheduler ~/<destination folder>/

Take a backup of System.properties

• Go to the Installation directory

  example

  (go to the installation directory)

  cd apache-tomcat-dbsync/dbsync-cdm/WEB-INF/db/conf

• Use the below command to copy the files present inside the conf folder

• cp system.properties ~/<destination folder>/

Take backup of <database>.properties files

• Go to the Installation directory

  example

  (go to the installation directory)

  cd apache-tomcat-dbsync/dbsync-cdm/WEB-INF/db/conf

• Use the below command to copy the files present inside the conf folder

• cp -r <database>.properties ~/<destination folder>/

  Example for MYSQL

  cp -r mysql.properties ~/<destination folder>/\

  Note: All the backup up folders/files need to be placed at the exact location in the new installation or upgrade location