// // How do I take backup and restore of ORO POS data | ORO POS – Point of Sale - POS System & Inventory How do I take backup and restore of ORO POS data – ORO POS – Point of Sale

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 type Backup Process Restore
Derby Single  Copy posdb folder in the database/derby-single  Move existing posdb folder and replace with posdb from backup.
Derby Server Copy posdb folder in database/derby-server ( if you have created database in different name,  you should copy that folder)  
PostgreSQL Follow 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
MySQL Follow backup process defined in MySQL official page
https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/mysqldump-sql-format.html
 
MSSQL https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-full-database-backup-sql-server?view=sql-server-ver15  

Disclaimer: The information and media included on this website are not legal documents. Whilst we make every attempt to ensure the accuracy and reliability of the information contained in the documents stored, served and accessed on this site, this information should not be relied upon as a substitute for formal advice from our company. Features described in this document are subject to change without any notice.