---
title: WorkspaceData backup and restoration
sidebar_label: Workspace data
---

Dashboards and other Web environment data are stored in the [`WorkspaceData`](../internal-tables/workspace-data.md) 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](./backup-and-restore.md#deephaven-backup-script).

## Workspace data tool

To export/import with the `WorkspaceDataTool`, use the following commands:

```bash
# 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](../configuration/workspace-data-tool.md) 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](./table-migration.md#migrating-intraday-data) 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:

```bash
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.

## Related documentation

- [Backup, Restore, and Migration overview](./backup-and-restore.md)
- [Configuration backup and restore](./configuration-properties-backup.md)
- [etcd and MySQL backup and restore](./etcd-and-acls-backup.md)
- [File system backup and restore](./configuration-files-backup.md)
- [Table migration](./table-migration.md)