Backup
We back the server up off-site eight times a day, and you can take your own copy at any moment without asking us.
- Download a full backup of your dataset from the dashboard, on demand.
- The backup is a PostgreSQL dump — restorable anywhere, by anyone.
- Eight off-site backups a day on top of that, kept encrypted.
- Backups can be emailed rather than downloaded.
- Restore a dataset from your own file if you need to roll back.
Taking a copy
- Open the control panel dashboard, find the dataset and press Backup. A PostgreSQL dump is prepared and downloaded, or emailed if you prefer.
- To restore, send us the file or upload it from the same place; the dataset is replaced as at the moment of the dump.
- Our own off-site backups run eight times a day regardless.
From inside the application
- System › Backup › Save to File downloads a SQL dump of the dataset through the browser; Send by E-Mail mails it to the address in your Preferences.
- To restore elsewhere: create an empty database, load the dump with
psql, and copy the templates folder alongside. That is all a SQL-Ledger dataset is.
From the blog
- Cloning SQL-Ledger dataset — Sometimes you need to create a new dataset with exact same customers, vendors, items, chart etc. from an existing dataset.
- Free forever SQL-Ledger Hosting — tl;dr: Signup here: https://account.ledger123.com/ From today we are offering free forever SQL-Ledger hosting. You can signup and create as many databases as you want to.
Every dataset on our hosting has this, from day one.
Create your free account or ask us about migrating