Purpose
Each company Admin will be responsible for taking (sql) backup of their SolutionERP database at regular intervals. In case upgrades or some bulk transactions go awry, a rollback would be necessary for which the restore option will be a godsend. This however comes with a security vulnerability for now with a variety of workarounds.
Procedure
Setup => Backup and Restore
Notes
- Only tables that match the company's prefix will be backedup.
- On restoration, these tables will first be dropped before being recreated and populated.
- Beware that the username and password for all users too will be overwritten on restoration as also the user preferences, language choices, etc.,.
- These backups are stored in the company's backup folder - in the screenshot above, for company 1 it is in company/1/backup relative to the webroot.
- Match the source backup file's table prefix to that of the target company before restoration into the latter.