The opFlow CLI provides methods to reset the database.
Stop the relevant services:
Drop and Prime the Database
By default, all opFlow data is stored in a database named 'flows', this is configurable and opCommon.nmis has this setting which defines the dbname used 'opflow_db_name' => "flows".
NOTE about DB size: when re-creating the database using opflow-cli, the following config variables will be used to determine how large to make the collections 'opflow_db_conversations_collection_size' => '16106127360' (15G), 'opflow_db_flows_collection_size' => 5368709120 (5G). These can be changed or overridden on the CLI by specifying usepercent=NN, which calculates the size the db will use based off of the percentage of of disk specified.
There are two options to clean up database data.
Remove all data, start from scratch. (See note above regarding db size)
# drop and re-create with correct size
.pl act=setup-db drop=
# add auth to new db
Drop flow/conversation data, keep all other data.
First Back up data to keep
Drop the database and re-create it. (See note above regarding db size)
Start all daemons back up.