FactoryWiz Monitoring Database Configuration: Backup, Retention, and Management

8.3.1 Database Backup

The Database Configuration window, shown in Figure 9‑72, allows you to select how long FactoryWiz™ Monitoring stores the data it collects from your machines.


The Backup Configuration window lets you specify where and when you want FactoryWiz™ Monitoring to create a backup copy of the data it records, and whether you want to retain only the most recent backup or save multiple backup copies.

Backup Location

You may choose to store the backup copies on a local drive or at a remote location.  If you choose a remote storage location, you must provide a UNC path and the credentials – username and password – to authenticate to that location.

NOTE: The folder you choose must already exist. If FactoryWiz™ Monitoring cannot find the folder you specify, it will not create one for you, but will instead save the backup into the server’s C:\BIN folder. 

To configure these settings, you will enter the name of the folder on the local drive or the UNC path for the backup storage location in the Target Location. If you are copying the backup to a remote location, enter the username and password necessary to access that location in the Target Credentials.

Schedule

The Schedule has drop-down menus to select how often you wish to back the data up and to pick which day of the week or month the data will be backed up. Select Daily, Weekly, or Monthly from the Frequency drop-down list. Note that backups will be made at approximately 1:00 AM on whichever day you select.

If you choose to back up your data weekly or monthly, use the On Day drop-down list to select the day that the data will be backed up.

If you have chosen to back up your data monthly, select a number from 1-28 from this list: 1 (Monday) to back up the data on the first day of each month, for example, or 15 to back up the data on the 15th day of the month.

Note that the first seven choices on this list contain both a number and a day of the week. If you choose to back your data up weekly, choose the day of the week by selecting one of the first seven choices.

If you select 1 (Monday) and weekly backups, your data will be backed up every Monday. If you select 1 (Monday) and monthly backups, your data will be backed up on the first day of the month, regardless of which day of the week that falls on.

Retention

Select the number of backups to retain from the Retention drop-down list.  If you choose to store only one backup, FactoryWiz™ Monitoring will automatically delete any older backups when a new backup is made. If you choose to save five copies, FactoryWiz™ Monitoring will save the five most recent copies, deleting the oldest backup as a new one is added.

When you have finished configuring your backup settings, you may either:

·         click Save to save the configuration settings; or

·         click Save & Backup to save the settings and make a backup during the next backup window, and then start the retention schedule that is configured.


    • Related Articles

    • MySQL Database Backup and Reload

      You will need to remote access to the FactoryWiz server to perform these procedures. NOTE: the password portion askusforthispassword in these commands is not the actual password. You will need the actual password for the root user. Please send an ...

    • 8.3.6 Full Database Wipe

      Full Database Wipe If you need to purge all the data collected and retained in the FactoryWiz™ Monitoring database, you may do so with a full database wipe. This is an irrevocable action – you will not be able to recover the data afterwards. NOTE: ...

    • 8.7.5 Removing A New Machine

      To remove a machine, you must remove the configuration data from the database. Click To remove a machine go to the Database page link to navigate to the Database Configuration window. See Database Configuration for instructions to remove a machine.

    • 8.3.5 MySQL Console

      MySQL Console FactoryWiz™ Monitoring provides a MySQL command console to access the database directly using T-SQL database commands. FactoryWiz™ recommends that only users with MySQL experience and training be authorized to open this console. To ...

    • 11 External Documentation

      FactoryWiz uses multiple external libraries and software packages. Here are links to vendor resources and manuals. · MySQL Database · Adam APAX Utility · Adam APAX Utility Manual · Moxa Device Manager Software · Moxa Nport Manual · Comtrol Manual · ...