Backup / Restore of Flowable database

Flowable Engine
1

Hi,

What is the best way to backup and restore flowable database?
Does it store everything in linked database or are there any other files elsewhere that must also be backed-up?

Thanks,
Deepanhu

2

See: Any suggestions on how to backup history level

3

@Robinyo I do not think this answers the requirement I have. I am looking for something that can help us take periodic backup of flowable server and then we can use the same to restore in case of build failure.

Thanks,
Deepanshu

4

Hey Deepanshu,

Flowable uses a normal database and there is nothing special that you need to take into consideration when doing a backup for the Flowable Database.

Cheers,
Filip

5

Thanks @filiphr. It helps. I am using BACKUP to ‘backup.zip’ for online backup.
Any recommendations on this.

6

Hi,
When history table become huge, there is a need for a proper mechanism to backup/purge them. Does flowable has any API or tools to do that?
Thank you!

7

You should be also saving a copy of the folder where Flowable keeps the attachments.

The property defining it is

flowable.content.storage.root-folder=/opt/flowable/data/
8

@dan : automatic cleanup can be configured. See https://flowable.com/open-source/docs/bpmn/ch11-History/#history-cleaning.