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.

Restoring Database Backups 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 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.

Products Affected

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.

Requirements

A Mac, Linux, or Windows server with the following components installed:

  • Jamf Pro 8.21 or later
  • jamfsoftware database

Procedure

To restore a database backup:

  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\

  1. Click the Restore Backup tab.
  2. Click Browse and choose the backup that you want to restore.
  3. Click Restore Backup Now.

Additional Information

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".

Like Comment
Order by:
SOLVED Posted: by christopher.kaczmare

Is it still required to have a GUI Version of Linux with JSS 9.65 to recover a backup?
Or can I use the OS X command line commands analog in linux ... ?

sudo java -jar /Library/JSS/bin/JSSDatabaseUtil.jar restore -file backup.sql.gz
Like
SOLVED Posted: by mire3212

@Patrick.Faust

The Linux installation guide has been updated with the steps on how to backup/restore the database without a GUI.

Refer to page 12.

Like
SOLVED Posted: by Mickael.diot

Hi,

I use this command in Linux :

sudo java -jar /usr/local/jss/bin/JSSDatabaseUtil.jar restore -file [myfile.sql.gz]

I have this result :

JSS Database Utility 9.73
Error: null

My archive seems OK (I have an SQL file inside).

Do you know why I get this error ?

Thanks

Like
SOLVED Posted: by donmontalvo

@Mickael.diot did you ever get this resolved?

I got the same error on OS X when I ran the usual command.

GUI works fine, I guess I'm spoiled, having run the command so many times.

Like
SOLVED Posted: by dlondon

Hi Mickael,

I had that error and resolved it by giving the full path to the backup.sql.gz (to use a generic name) file

Regards,

David

Like
SOLVED Posted: by benducklow

Is there any way to tell the progress of the restore? My database if ~650MB compressed and bailed on it about 1.5hrs into it.. According to the logs, it only takes 10 minutes to actually do the backup to begin with. Very frustrating

Like
SOLVED Posted: by ron.heck

This article is no longer being updated.

Like