Manually backing up and restoring Knox tables

You need to manually back up and restore the Knox tables as the knox_gateway database is not included automatically in the Data Lake backup and restore process. The knox_gateway database includes tokens, client credentials and API keys stored in tables.

Ensure the following when backing up and restoring the Knox tables:
  • Because the knox_gateway database contains token information, you must review all tokens, especially long-lived credentials like Client Credentials and API Keys, after restoring the database from a backup. This step is essential because tokens may have been revoked or disabled in the time between the backup was created and the restoration occurred.
  • Any unexpired Knox tokens are removed from the Knox tables that have been removed since the backup was created.
  • Any new Knox tokens are present in the Knox tables that were created after the backup was taken.