Restoring a server database from a backup file

Last Updated : Jan 23, 2023 |

About this task

Use the Maintenance Shell to restore database files on the Configuration Server from a backup file. The restore operation removes the current databases and replaces them with the backup databases. You cannot revert the database restore operation.

You can also run maintenance commands on the Configuration Server console.

Procedure

  1. On the Configuration Server web portal, log in to the Maintenance Shell console as the mega user.
  2. Run the mtc restore server command.
  3. Enter the database server IP address at the Enter Db server IP address prompt.

    For example, enter: 10.104.2.19.

  4. Enter the database password at the Enter Db password prompt.
  5. Enter the database host port at the Enter Db host Port prompt.

    The default port is 5432.

  6. Enter the backup mode at the Enter Backup Mode prompt.

    Enter 1 for Local backup or 2 for Remote backup.

  7. Enter the directory to back up the server backup file.

    For example, enter: /tmp/.

  8. Enter a username at the Enter Remote Username prompt.
  9. Enter a password at the Enter Remote password prompt.
  10. Enter a passphrase at the Enter passphrase prompt.

    The Maintenance Shell console displays the results of the restore operation.