SQL-Ledger Backup

revised: 19-Feb-2022

ensuring means to perserve data and the application - a two part process

a. Backup - Database only:

To backup the database structure and transactions, one selects within SQL-Ledger's table of actions: System->Backup->Save to File. A dialogue box should pop-up requesting one to save the backup file to one's download directory whose title should be in the form of:

[database-name]-[version of SQL-Ledger]-[current date].sql.gz.

For example: testdb-3.2.10-20200522.sql.gz Note: If one chooses "Send by Email" instead of the recommended "Save to File" in the default install then these backup files accumulate in the "users" directory on the server if the email dependencies and configuration is not properly setup.

It is recommended to do this daily, if not more frequently when many entries are posted.

b. To backup the SQL-ledger application together with users and templates

Via PuTTY, logon as the regular user (eg. sammy) and go to the /usr/local directory. One can compress the entire sql-ledger directory into a file named: [MyServerName]-SQL-ledger3.2.10-[date].tar.gz as follows:

With an FTP client (eg. FileZilla), download the file: [MyServerName]-SQL-ledger3.2.10-[date].tar.gz and store it well. It is recommended to do this application backup, particularly when there are many changes with users and/or templates.