KB 10146 How to move database to remote server

Owned by Krzysztof Szawara
Last updated: Aug 01, 2023
1 min read

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 -pROOTDBPASSWORD -e "create database vprotect character set utf8 collate utf8_unicode_ci")

  5. Create user with privileges for vprotect database:

    mysql -uroot -pROOTDBPASSWORD -e "CREATE USER 'vprotect'@'localhost' IDENTIFIED BY 'DBPassword'" mysql -uroot -pROOTDBPASSWORD -e "GRANT ALL PRIVILEGES ON vprotect.* TO 'vprotect'@'localhost' WITH GRANT OPTION" mysql -uroot -pROOTDBPASSWORD -e "CREATE USER 'vprotect'@'%' IDENTIFIED BY 'DBPassword'" mysql -uroot -pROOTDBPASSWORD -e "GRANT ALL PRIVILEGES ON vprotect.* TO 'vprotect'@'%' WITH GRANT OPTION" mysql -uroot -pROOTDBPASSWORD -e "FLUSH PRIVILEGES"

  6. import database into MariaDB: gunzip < PATH_TO_GZIPPED_BACKUP | mysql -uroot -pROOTDBPASSWORD vprotect

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

  8. 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

     

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

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