Got it

How to recover the UMS data

Created: Feb 5, 2020 06:31:21Latest reply: Feb 19, 2020 12:57:08 477 2 0 0 0
  Rewarded HiCoins: 0 (problem resolved)

Hello, experts!

Have a good day!

When I recover the data on the UMS, the network is interrupted suddendly, and the oparation is failed and data is lost! Do you have any method to help me to find the data?  Waiting for your reply ,thanks!

Featured Answers

Recommended answer

Hey,girl
Created Feb 5, 2020 06:43:24

Hi, Ava!

Thanks for choosing our community!

Which network does your UMS install? Stand-alone system or dual system?

The following way is applicable to stand-alone system.

  1. Get back data to UMS

    Login in to UMS system use root account,input follow command:

    cd /usr/local/aserver

    input  sftp sftp_user@sftp_server_address

    input sftp password

    input follow command to restore data after access to the sftp server

    get -r storage

    wait for coping the data.

    note:

          sftp_user: account of the sftp server

          sftp_server_address: address of the sftp server

    input follow command to exit the sftp when data coping is finished.

    quit

  2. Into the storage Folder.

    cd storage                             

  3. Restore the configuration file

    tar xzvf ums_cfg.tar.gz -C /usr/local/aserver/conf

  4. Input follow command to restore database

    cp ums_db.sql /home/postgre

    chown postgre:postgre /home/postgre/ums_db.sql

    su postgre

    cd

    /usr/local/pgsql/bin/psql  aserver < ./ums_db.sql

    exit

  5. Reboot the server

    restart

    After restoring the data, the system data will be restored to the state when executing backup.


Please try the above steps to resolve your problem, if it cannot resolve the problem, please let me know!

View more
  • x
  • convention:

All Answers

Hi, Ava!

Thanks for choosing our community!

Which network does your UMS install? Stand-alone system or dual system?

The following way is applicable to stand-alone system.

  1. Get back data to UMS

    Login in to UMS system use root account,input follow command:

    cd /usr/local/aserver

    input  sftp sftp_user@sftp_server_address

    input sftp password

    input follow command to restore data after access to the sftp server

    get -r storage

    wait for coping the data.

    note:

          sftp_user: account of the sftp server

          sftp_server_address: address of the sftp server

    input follow command to exit the sftp when data coping is finished.

    quit

  2. Into the storage Folder.

    cd storage                             

  3. Restore the configuration file

    tar xzvf ums_cfg.tar.gz -C /usr/local/aserver/conf

  4. Input follow command to restore database

    cp ums_db.sql /home/postgre

    chown postgre:postgre /home/postgre/ums_db.sql

    su postgre

    cd

    /usr/local/pgsql/bin/psql  aserver < ./ums_db.sql

    exit

  5. Reboot the server

    restart

    After restoring the data, the system data will be restored to the state when executing backup.


Please try the above steps to resolve your problem, if it cannot resolve the problem, please let me know!

View more
  • x
  • convention:

hello dear

Restoring a File-Based Backup
  1. Open the UMS Administrator, and go to Data Source in the menu on the left.

  2. In the Data Source area, delete the corrupted Derby DB.

  3. Create a new embedded DB with exactly the same user name and password as you used for the deleted DB.

  4. Deactivate the newly created DB.


View more
  • x
  • convention:

Comment

You need to log in to comment to the post Login | Register
Comment

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
  • Politically sensitive content
  • Content concerning pornography, gambling, and drug abuse
  • Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Login and enjoy all the member benefits

Login

Block
Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Reminder
Please bind your phone number to obtain invitation bonus.