Restoring Database Backups Using the Jamf Pro Database Utility
Disclaimer: This article is no longer being updated. The Jamf Pro database utility was discontinued with Jamf Pro 10.14.0. For instructions on restoring the database using Jamf Pro Server Tools, see the following Knowledge Base articles:
- Restoring Database Backups Using Jamf Pro Server Tools
- Backing Up and Restoring the Database Using the Jamf Pro Server Tools Command-Line Interface
This article explains how to restore a database backup using the Jamf Pro database utility with v8.2. The Jamf Pro Installer installs the database utility when you install or upgrade Jamf Pro.
Jamf Pro 8.2, Imaging Suite 8.2, Recon Suite 8.2
Note: If you are using a different version, see your product documentation for instructions on how to restore a database backup.
A Mac, Linux, or Windows server with the following components installed:
- Jamf Pro 8.21 or later
- jamfsoftware database
To restore a database backup:
- 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:
On Linux this is located at:
On Windows this is located at:
- 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.
- 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:
On OS X v10.7 and Linux, the standard location is:
On Windows, the standard location is:
C:\Program Files\MySQL\MySQL Server 5.1\bin\
- Click the Restore Backup tab.
- Click Browse and choose the backup that you want to restore.
- Click Restore Backup Now.
For instructions on how to back up the jamfsoftware database, see “Backing Up the Database Using the Jamf Pro Database Utility”.
For instructions on how to restore a database backup from the command line, see "Restoring Database Backups from the Command Line Using the Jamf Pro Database Utility".