The following gives you steps on how to setup the database engine to perform automatic backups.

Note: You require DayLite 1.7.1 or higher and OpenBase 8.0.4 (included with 1.7.1) or higher. The process has not changed for Daylite versions up to Daylite 3.2.2.

If you are using Daylite 3.2.3 and want to automate your backups, the procedure is same as below. If you change the default backup directory, the owner should be changed to 'openbase.' You can do this by selecting the location, choosing File > Get Info, and setup the owner to be 'openbase.'

Please note that the backup location for local databases cannot contain any spaces. Please select a location which does not contain spaces.

1. Launch OpenBaseManager (in /Applications/OpenBase/).
2. Click on Local on the top left of the window.
3. Select your database.
4. From the menu, select Action -> Configure Database (a small window with several tabs will appear).
5. Select the Backup tab.
6. Check Create a compressed copy of the database.
The location field becomes enabled. If you change the path, please ensure that you have the correct unix path. For external hard drive, don't forget to include /Volumes in the path. If the path is incorrect, the backup will fail with no warning! The path must be folder and should not include trailing slash at the end. This path must be accessible and writable by the OpenBase process at all times.
7. Now schedule the backup. You must ensure that this computer is actually ON at that time and that CPU hogging processes are not likely to run at that time.
8. Close the window using the red 'close window' button on the top left of the window.
9. Confirm that you want to save the changes.
10. Quit OpenBaseManager.


Please check that the backup has indeed been performed according to the selected schedule. Check the backup folder location so that there is a new .tgz file. The backup naming convention consists of the database name followed by a timestamp, followed by .tgz

Example: MyDayLite_2005-01-15_03-45.tgz

Note: This backup process trims the SQL logs.