How to backup and restore or database

Custom Deployment
1

How to backup and restore OR database please tell me.

2

I guess you’re using docker, an easy way would be a backup of the volume. You can then use it for restoration.

1 Like
3

HEY THERE @vamsi
To BACKUP and RESTORE your data you must follow these steps:
FOR BACKUP

  • Open your database management tool (e.g., MySQL Workbench, pgAdmin, etc.).
  • Select the database you want to backup.
  • Choose the “Export” option from the menu.
  • Select the format you want to save the backup in (e.g., SQL file).
  • Specify the location to save the backup file.
  • Start the export process and wait for it to complete.

FOR RESTORING

  • Open your database management tool.
  • Select the database where you want to restore the backup. If the database doesn’t exist, create a new one.
  • Choose the “Import” option from the menu.
  • Select the backup file you previously created.
  • Start the import process and wait for it to complete.
1 Like
4

@vamsi @shawn

We have some useful commands in the OpenRemote wiki here:

This describes how to backup and restore the OpenRemote database

2 Likes
5

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.