Skip to main content
Jamf Nation, hosted by Jamf, is the largest Apple IT management community in the world. Dialog with your fellow IT professionals, gain insight about Apple device deployments, share best practices and bounce ideas off each other. Join the conversation.

Backing Up the Database Using the Jamf Pro Database Utility

Overview

Note: The Jamf Pro database utility is incompatible with MySQL 8.0 and will be discontinued in an upcoming release of Jamf Pro. To back up the database using Jamf Pro Server Tools, see the Backing Up the Database Using Jamf Pro Server Tools Knowledge Base article.

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