WorkspaceData backup and restoration
Dashboards and other Web environment data are stored in the WorkspaceData table in the DbInternal namespace. It can be backed up by exporting/importing CSV using the WorkspaceDataTool, by copying the intraday table, or by copying the most recent WorkspaceDataSnapshot. However, the preferred method is the Deephaven backup script.
Workspace data tool
To export/import with the WorkspaceDataTool, use the following commands:
# Export Workspace data:
sudo -u irisadmin /usr/illumon/latest/bin/iris workspace_data_tool -c -t Workspace -f [workspace_filename].csv
# Restore Workspace data:
sudo -u irisadmin /usr/illumon/latest/bin/iris workspace_data_tool -rc -f [workspace_filename].csv
# Export Dashboard data:
sudo -u irisadmin /usr/illumon/latest/bin/iris workspace_data_tool -c -t Dashboard -f [dashboard_filename].csv
# Restore Dashboard data:
sudo -u irisadmin /usr/illumon/latest/bin/iris workspace_data_tool -rc -f [dashboard_filename].csv
For a complete listing of options, see the full workspace_data_tool documentation.
Once the restoration steps are completed, restart the WebClientData Persistent Query.
Intraday table migration
You can copy the WorkspaceData table by following the instructions in the related Table migration document.
WorkspaceDataSnapshot historical migration
Alternatively, if historical changes of items with the table are not required, the contents of WorkspaceData may be transferred using a single WorkspaceDataSnapshot partition by ensuring a new snapshot is taken (by manually executing the WorkspaceSnapshot Persistent Query) and copying it to the new deployment. The latest snapshot can be found with the following command on the source host:
find /db/Systems/DbInternal/Partitions -name 'WorkspaceDataSnapshot' | sort -t '/' -k6
Once the latest snapshot has been identified, the single partition may be copied to the target or made available through NFS, if possible.