Backing Up the Database

You can create database backups as needed, or you can schedule database backups to be created automatically on a schedule. The time it takes to create a backup depends on the size of the database.

When you schedule database backups, you can also automate the deletion of scheduled backups that are older than a certain number of days.

Creating a Database Backup

  1. Open the JSS Database Utility.

  2. Enter the username and password for an administrator account to the server, and click OK.

  3. If the JSS Database Utility is unable to locate the MySQL binary, you are prompted to enter the path. Click Continue and enter the full path to the binary.

  4. If the Database Connection Setup pane appears, configure the settings to match your database configuration and click Apply Settings.

  5. Click Save Backup Now.
    images/download/attachments/5145216/Mac_Backup_Restore.png

  6. Select the location where you want to save the backup and click Choose.

The JSS Database Utility creates the backup and saves it as a .sql.gz file.

Scheduling Database Backups

  1. Open the JSS Database Utility.

  2. Enter the username and password for an administrator account to the server, and click OK.

  3. If the JSS Database Utility is unable to locate the MySQL binary, you are prompted to specify the path. Click Continue and enter the full path to the binary.

  4. If the Database Connection Setup pane appears, configure the settings to match your database configuration and click Apply Settings.

  5. Select the Schedule automatic backups for checkbox and choose the hour of the day that you want backups to occur.

  6. To save the backups in a custom location, click Change and select a new location.
    images/download/attachments/5145216/Mac_Schedule_Backup_Stop_Schedule_Backup.png

  7. To automate the deletion of scheduled backups, select the Delete backups older than checkbox and choose the number of days after which backups should be deleted.

The JSS Database Utility creates daily backups at the hour you specified. It also deletes scheduled backups older than the number of days you specified.

Stopping Scheduled Database Backups

  1. Open the JSS Database Utility.

  2. Enter the username and password for an administrator account to the server, and click OK.

  3. If the JSS Database Utility is unable to locate the MySQL binary, you are prompted to enter the path. Click Continue and enter the full path to the binary.

  4. If the Database Connection Setup pane appears, configure the settings to match your database configuration and click Apply Settings.

  5. Deselect the Schedule automatic backups for checkbox.
    images/download/attachments/5145216/Mac_Schedule_Backup_Stop_Schedule_Backup.png

The JSS Database Utility stops creating scheduled backups immediately.

Related Information

For related information, see the following section in this guide:

Restoring Database Backups
Find out how to restore a database backup.

Copyright | Privacy | Terms of Use | Security
Copyright JAMF Software, LLC 2016