KB 10146 How to move database to remote server

KB ID: 10146

Product: Storware Backup & Recovery

Version: 5.x 6.x

Published: 2023-07-31

Last modified: 2023-07-31

Problem

How to move vprotect database into remote database server.

Solution

1. Stop Storware Backup & Recovery server: # systemctl stop vprotect-server

2. Create database backup from existing server: # /opt/vprotect/scripts/backup_db.sh

3. Copy /tmp/vprotect_db.sql.gz to MariaDB server (example # scp /tmp/vprotect_db.sql.gz root@mariadb.server.address:/tmp)

4. Create database (example # mysql -uroot -pDBPASSWORD -e "create database vprotect")

5. import database into MariaDB: gunzip < PATH_TO_GZIPPED_BACKUP | mysql -uroot -pDBPASSWORD vprotect

6. On Server Machine edit # vi /opt/vprotect/payara.properties

7. Uncomment and set correctly variables (if you use FQDN names you need to set it in /etc/hosts or in DNS server). You need set address to MariaDB, listening port and Password to database:

   eu.storware.vprotect.db.host=mariadb.server.address
   eu.storware.vprotect.db.port=3306
   [...]
   eu.storware.vprotect.db.password=DBPassword

8. Start Storware Backup & Recovery server: # systemctl start vprotect-server

9. If necessary restart nodes # systemctl start vprotect-node