How do I take backup and restore of ORO POS data

ORO POS stores both images and data inside the database. So a store needs to set up a practice scheduled backup of database either daily or weekly.  

Before you backup

a. Shutdown all terminals.

b. Arrange an external hard drive or cloud based drive like dropbox. 

Database typeBackup ProcessRestore
Derby Single Copy posdb folder in the database/derby-single Move existing posdb folder and replace with posdb from backup.
Derby ServerCopy posdb folder in database/derby-server ( if you have created database in different name,  you should copy that folder) 
PostgreSQLFollow latest backup process recommended by Postgres
https://www.postgresql.org/docs/9.5/backup.html
https://www.postgresql.org/docs/9.4/backup-dump.html
MySQLFollow backup process defined in MySQL official page
https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/mysqldump-sql-format.html
 
MSSQLhttps://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-full-database-backup-sql-server?view=sql-server-ver15