While your data is backed up every night in the cloud, there are circumstances under which you might want to save a backup locally. If, for example, you're planning to import data into an existing database, it's a good idea to make a backup first. If something goes wrong or the results aren't what you expected, restoring a backup is an easy way to undo things.

BACKUP YOUR DATA

• Click the Utilities icon in the main menu then Backup/Restore.
• Click Backup. Your data will be saved in your downloads folder as Waterwheel-backup-yyyymmdd-hhmmss.sql, where yyyymmdd and hhmmss are the date and time the backup was created (hh uses a 24-hour clock).

This saves your cloud data onto your local computer. Your entire database is saved as a set of SQL statements. If you want just a portion of your data or want it in a form that can be used in a spreadsheet, open the screen you want, click the Reports icon in the grid menu then one of the Export options.

RESTORE A BACKUP FILE

• Click the Utilities icon in the main menu then Backup/Restore.
• Click Choose file, navigate to and click on the backup file you want then click Open.

This restores the data saved with the Backup command to the cloud. Your entire database is restored. If you want to update a portion of your database from a file, consider importing it.