dcsimg

How do I manually run a backup process for a profile or configuration?

0

Products

Webtrends Analytics 9.x
Webtrends Analytics 8.x

Issue

How do I manually run a backup process for a profile or configuration?

Resolution

The instructions below will be referencing Profile_ids and an Account_id. The Profile_ids are found within the MySQL or SQL wtMaster database, in the wt_profile table.

Steps to find the profile_id:

  1. In the UI of Webtrends, edit the profile you would like to backup.
  2. Make a note of the “Profile File Name”. This will be an alpha-numeric character such as “kXmkklXWla6”.

Once the “Profile File Name” is located, run the following query against the wt_profile table in the wtMaster MySQL or SQL database:

SELECT ProfileID FROM wt_Profile WHERE WRC_ProfileID = ‘kXmkklXWla6‘

The results returned will be the profile_id, which will be used in the instructions below.

Backup Utility Instructions:

From command line, navigate to \webtrends\modules\tools.

Here are the command line switches for running the backup utility manually:

Display the program’s version information:
BackupUtility.exe -v or BackupUtility.exe –version

For Backups:

Profile Backup – BackupUtility.exe -backup_profile wtl_profile_id=<number retrieved above>
Account Configuration Backup – BackupUtility.exe -backup_config wtl_account_id=1

For Restores:

Restores require that you find the file name of the backup that you want restored. The filename will be in the following format in the location:

\\storage\backup\<Profile File Name>\Archives\archive_<yyyymmdd-hhmmss>.zip

Please note that the <yyyymmdd-hhmmss> is the time that the archive was created, not the time that it will restore to. If you’re unsure of what time the data will be restored to, you can check the “LastProcessed” in the status.ini file included in the zip file.

BackupUtility.exe -restore_profile wtl_profile_id=<number retrieved above> date=<yyyymmdd-hhmmss>

For Resets:

WARNING: THIS IS JUST LIKE PERFORMING A REANALYSIS IN THE USER INTERFACE… ALL HISTORICAL DATA FOR THE PROFILE WILL BE WIPED INCLUDING BACKUPS MADE FOR THE PROFILE WITHIN THE SOFTWARE

BackupUtility.exe -reset_profile wtl_profile_id=<number retrieved above>

This is helpful if you want to manually run a back up job w/o creating a scheduled event or if you want to reset a profile while changing the start date.