Skip to main content
Jamf Nation, hosted by Jamf, is a knowledgeable community of Apple-focused admins and Jamf users. Join us in person at the ninth annual Jamf Nation User Conference (JNUC) this November for three days of learning, laughter and IT love.

Backing Up the Database Using the Jamf Pro Database Utility

Overview

Disclaimer: This article is no longer being updated. The Jamf Pro database utility was discontinued with Jamf Pro 10.14.0. For instructions on backing up the database using Jamf Pro Server Tools, see the following Knowledge Base article:
Backing Up the Database Using Jamf Pro Server Tools

This article explains how to back up the jamfsoftware database and schedule database backups using the Jamf Pro database utility. The Jamf Pro Installer installs the database utility when you install or upgrade Jamf Pro.

Note: The Jamf Pro database utility is a Java application that requires a GUI-based operating system. The Jamf Pro database utility for Linux includes a command-line version (jssdbutilcli.run) for those running non-GUI versions of Linux. It allows you to schedule database backups to occur daily at 3 a.m. It does not allow you to customize the backup schedule or create an individual database backup.

Procedure

To back up the jamfsoftware database:

  1. On the server that has the Jamf Pro and the jamfsoftware database installed, locate and open the Jamf Pro database utility (JSSDatabaseUtil.jar).
    • On Mac this is located at: /Library/JSS/bin/JSSDatabaseUtil.jar
    • On Linux this is located at: /usr/local/jss/bin/JSSDatabaseUtil.jar
    • On Windows this is located at: C:\Program Files\JSS\bin\JSSDatabaseUtil.jar
  2. Authenticate to the server when prompted. If you are using a Windows server with the User Account Control settings enabled, enter credentials for the built-in administrator, not a local account.
  3. If the Jamf Pro database utility is unable to locate the path to the MySQL binary, you are prompted to specify the path. Click Continue and select the location of the binary.
    • On OS X v10.6, the standard location is: /usr/bin/
    • On OS X v10.7 and Linux, the standard location is: /usr/local/MySQL/bin/
    • On Windows, the standard location is: C:\Program Files\MySQL\MySQL Server 5.1\bin\
  4. To save the backup to a custom location, click Browse and select a new location.
  5. Click Save Backup Now.

To schedule database backups:

  1. On the server that has the Jamf Pro server and the jamfsoftware database installed, locate and open the Jamf Pro database utility (JSSDatabaseUtil.jar).
    • On Mac this is located at: /Library/JSS/bin/JSSDatabaseUtil.jar
    • On Linux this is located at: /usr/local/jss/bin/JSSDatabaseUtil.jar
    • On Windows this is located at: C:\Program Files\JSS\bin\JSSDatabaseUtil.jar
  2. Authenticate to the server when prompted. If you are using a Windows server with the User Account Control settings enabled, enter credentials for the built-in administrator, not a local account.
  3. If the Jamf Pro database utility is unable to locate the path to the MySQL binary, you are prompted to specify the path. Click Continue and select the location of the binary.
    • On OS X v10.6, the standard location is: /usr/bin/
    • On OS X v10.7 and Linux, the standard location is: /usr/local/MySQL/bin/
    • On Windows, the standard location is: C:\Program Files\MySQL\MySQL Server 5.1\bin\
  4. To save the backups to a custom location, click Browse and select a new location.
  5. Select the Schedule automatic database backups for checkbox and then choose a time from the pop-up menu.

Selecting the Schedule automatic database backups for checkbox enforces the backup schedule immediately.

Database backups older than seven days are flushed automatically. If you want to keep backups that are more than seven days old, you must archive them.

Additional Information

For instructions on how to restore a database backup, see Restoring Database Backups Using the Jamf Pro Database Utility.

For instructions on backing up the database from the command line, see Backing Up the Database from the Command Line Using the Jamf Pro Database Utility.

Like Comment
SOLVED Posted: by ron.heck

This article is no longer being updated.

Like