Introduction:
In case of an unfortunate event where the customer has lost the master.db, it is possible to recreate it using a recovery script, Provided the actual artifacts are present in the data directory.
However, it is important to note that not everything can be recovered, and this procedure should be considered a disaster recovery option. Please exercise caution and verify with the engineering team before running this script on actual customer environments.

Recovery Script:
The recovery script provided here is specific to DAI version 1.10.2. You can find the script at the following location: https://github.com/h2oai/h2oai/blob/rel-1.10.2/db_restore.py

Conclusion:

This post serves as internal knowledge sharing. It is important to follow proper protocols and consult with the engineering team before implementing this disaster recovery procedure in real customer environments.

Usage: python -m scripts.construct_db --user h2oai [OPTIONS]

Options:
  --all_users                 List users.
  --user TEXT                 Limit the DB re-constrton to just this
                              selected user.  --db_name FILE              Database Sqlite file.  [de
                              master.db;required]
  --data_directory DIRECTORY  Data directory to scan.  [default:
                              ./tmp;required]
  -v, --verbose               Verbose logging.
  --help                      Show this message and exit.