4.8. Deleting Workspaces

Engineering Knowledge Manager

Administration Guide | Chapter 4: Creating and Managing Workspaces |

4.7. Renaming Workspaces |  | 4.9. Migrating Workspaces
Prev |  | Next

## 4.8. Deleting Workspaces

You can delete a workspace interactively using the EKM Server Administration interface. Once the workspace has been deleted from the list of active workspaces in EKM, you can manually delete the files and database tables corresponding to the workspace.

### Removing a Workspace from EKM

The first step in deleting a workspace is to remove the reference to it in EKM.

1. Ensure all users have logged out of the workspace that you wish to delete.

2. Sign in to the EKM Administration Interface as `superuser` (see Signing In and Out of EKM Server Administration). Select a workspace and click Delete Workspace. This opens the Delete Workspace dialog box.

3. Click OK to confirm that you want to delete the selected workspace.

4. When the operation is complete, the Delete Workspace Completed dialog box appears. Make note of the schema prefix which is required for deleting database tables. The schema prefix is also written to the log file. Click Close.

### Deleting Files and Database Tables Associated with a Removed Workspace

When you remove a workspace from EKM, various files and database tables associated with that workspace remain on the EKM server. The instructions below demonstrate the deletion of these remaining files for an EKM server that utilizes a MySQL database server. If you use a different database, the database commands for viewing and deleting tables will be different.

1. Stop the application server in which EKM is running. If EKM is installed in a clustered installation, stop the application server on each cluster node.

2. Delete the workspace from the database. To do this you will need to remove all the tables corresponding to the workspace from the EKM database. Assuming the name of database is `ekm` and the name of the workspace that you want to remove is `Temp`, then the following sequence of commands show how to remove the tables from a MySQL database.

   Open the MySQL client console:

   1. Switch to the EKM database by issuing the command:

          use ekm;

   2. List all the tables within this database by issuing the command:

          show tables;

   3. Delete all the tables whose prefix matches the schema prefix for the deleted workspace. When deleting a workspace using the EKM Server Administration interface, the schema prefix will be displayed and written to the log file.

      The following series of commands will delete the tables that begin with the schema prefix "R2":

          drop table r2_root_binval;drop table r2_root_bundle;drop table r2_root_names;drop table r2_root_refs;
          drop table r2_vn_binval;drop table r2_vn_bundle;drop table r2_vn_names;drop table r2_vn_refs;

3. When you restart the application server, the workspace will no longer be listed in any drop-down list in EKM.

Contains proprietary and confidential information of ANSYS, Inc. and its subsidiaries and affiliates.

Prev | Up / Contents | Next

Release 18.2 - © ANSYS, Inc. All rights reserved.