MySQL databases

To offer an enhanced solution, standalone Cove Data Protection (Cove) replaced Backup and Recovery. Where Backup and Recovery has been enabled and continues to be so for devices, the options presented here are still available.

If Backup and Recovery options are not present in your N-sight RMM, you need to use Cove.

To start a 30-day free trial of Cove, click the app switcher in the Product Bar, and select Cove Data Protection (Cove).

The MySQL plugin (data source), which supports MySQL 5.0 or higher, is available from Backup & Recovery 2014.

Hot (online) backups are supported for MySQL 5.0 and 5.1, while cold (offline) backups are available for MySQL 5.5 and 5.6.

Hot backups are taken while the database is running. They do not affect the normal data operation and capture changes made to the database whilst the backup is running. Hot backups are particularly useful where the size of the database would results in a cold backup taking too long or where the database must remain operational 24/7.

Backup

To backup MySQL databases:

  1. Launch the Backup Manager
  2. Select the Backup tab
  3. In the Available sources click Add
  4. Expand the required MySQL Databases

    5. It may be necessary to click the MySQL server name to display the node structure

  5. Select the required databases
  6. Once the selection is complete click Save to apply
  7. Configure the MySQL Schedule
  8. Amend the Backup & Recovery Check to take account of the increased backup jobs

To amend the selected data sources:

  1. Launch the Backup Manager
  2. Go to the Backup tab
  3. Click Edit expand the node and change the selection