The following gives you steps on how to setup the database engine to perform nightly 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.7.5.

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

• Launch OpenBaseManager (in /Applications/OpenBase/)
• Click on Local on the top left of the window
• Select your database
• From the menu, select Action -> Configure Database (a small window with several tabs will appear)
• Select the Backup tab
• 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.
• Now schedule the backup. Select 'Every Day' in the first schedule popup, then select 2am in the second popup. 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.
• Close the window using the red 'close window' button on the top left of the window
• Confirm that you want to save the changes
• Quit OpenBaseManager

The following day, please check that the backup has indeed been performed. Check the backup folder location to that there is a new .tgz file. The backup naming convention consists of the database name followed by a timestamp, followed by .tgz


Note: This backup process trims the SQL logs.