Login  Sign up

How to setup and restore database "Backups"?

Backups vs Full Backups

BACKUPS include your farmerswife database (current45.efdb) and the SQL-lite databases (fwdb.db3 and despatches.db3), and get stored within the "backups" sub-folder within the farmerswife Server's "system" folder. The "Backups" should typically be stored according to the "Backup Every" setting ... every 15 min.!

FULL BACKUP is a complete "mirror" copy process of the fw Server's root installation directory/package, which by default includes all files and clips. 

IMPORTANT: Please make sure that you provide enough storage capacity depending on the type and quantity of files you will be using within farmerswife.

Backup Every: Choose how often the fw Server will do a "DB Save" process (recommended best practice and default is Backup Every: 15 min.).

Backups: Select the amount of Backups to be "kept" and thus stored within the "backups" folder, i.e. once that number is reached the oldest backup will be deleted. Note: if you do a mouse over the word "Backups" you will see the behaviour of the "Auto" option.

Full Backup Time: Select at what time the farmerswife Server shall perform the Full Backup. The Server application must be running at that time.

Full Backups: Select the amount of Full Backups to be stored, i.e. once that number is reached the oldest full backup will be deleted.

Zip Backups: By default this setting is disabled in order to improve the stability and performance of your system. Do NOT enable it! This is a legacy setting, which can cause random low level crashes. Also this setting will be removed in the foreseeable future.

Full Backup Folder: This is the specific network path pointing to the 'Full Backup' folder. We recommend creating a new backup-folder on a different physical hard drive, as a sensible precaution against data loss. Please make sure that the Server applicationhas access to this folder and that the path is correctly defined.

Include Files Folder In Full Backup: Select "Yes" to include all files and clips in your "Full Backup" folder. This setting together with the amount of data you have stored within the "files" folder has direct implications on how long the Full Backup process will take.

Forced Shutdown: This functionality provides automated nightly restarts of your WIFE system. Select Yes if you wish to restart the Server during the night.

Mode: By default it is set to "Restart". But if you are running the farmerswife Server as a service of your operating system, select "Quit" and define your desired settings within your operating system.

Time: Select the time when the defined action should take place.

Manual Backup Operations:

  • Backup Now: By clicking this button on the running fw Server application window you manually initiate the standard database back-up process. In the Server Log Window you will now see “Manual Database Save” followed by the 5-step "DB Save" process.
  • Full Backup Now: Click this button on tthe running fw Server application window to create a manual "Full Backup" of the farmerswife Server application. This operation is recommended to be done before an upgrade of the fw Server application or any other modifications within the installation folder structure. The Full Backup path can be set to the local machine or any host which is accessible through the LAN. We recommend to NOT store the "Full Backups" on the same volume/disk as where the fw Server application is installed!

How to restore a Backup:

To restore a backup, shut down (Quit) the fw Server application (notify all connected users first), and access the application installation directory.

  1. Go to the "system" folder and re-name each of the existing files: current45.efdb, fwdb.db3 and despatches.db3 files, to e.g."prev_current45.efdb", etc..
  2. Go to the "backups" folder which is located within the "system" folder, view the files in list mode and sort them by "Date Modified", so you can find the latest backup files.
  3. Copy all three files as in step "1." with the same ID and paste them into the "system" folder. Now rename each of them according to their file type extension: current45.efdb, fwdb.db3 and despatches.db3.
    Rename example:
    id201707271315290000001488.efdb => current45.efdb
    id201707271315290000001488.db3 => fwdb.db3
    id201707271315290000001488_despatches.db3 => despatches.db3
  4. Now you are ready to start the fw Server with the recovered backup files.

Did you find it helpful? Yes No