Please rate how useful you found this document: 
Average: 1.7 (3 votes)

Overview

Before ProcessMaker version 2.8, three MySQL databases were created for each workspace: wf_WORKSPACE, rp_WORKSPACE and rb_WORKSPACE.

In version 2.8.0 and later, workspaces only use one database wf_WORKSPACE, which by default is named "wf_workflow". Nonetheless, version 2.8 can still use three databases for workspaces that were upgraded from a previous version of processmaker. This change simplifies database queries, facilitates better data management and backup, makes it easier to install ProcessMaker on hosted systems that limit the number of databases, and works better with some Enterprise features.

Unifying the databases in version 2.8 and later

If ProcessMaker was upgraded to version 2.8, then the workspaces from previous versions of ProcessMaker will continue using 3 databases in version 2.8. Nonetheless it is possible to merge the three databases into one. A merged database may speed up actions which previously required queries to multiple databases, such as login and writing to Report Tables.

The processmaker unify-database command is available in version 2.8.0 and later to merge the three databases per workspace into one database.

Note: The processmaker unify-database command is ONLY available in the ProcessMaker Enterprise Edition 2.8.0 and later. If using the Community Edition, it is not possible to merge the 3 databases for each workspace into one. However, any workspace created in version 2.8.0 and later will only have one database.

To run this command, open a command-line terminal and change to the ProcessMaker installation directory. (It may be necessary to change to the Administrator user in Windows or the root user in Linux/UNIX depending where ProcessMaker is installed.)

To unify the databases of all the workspaces, issue the command:

processmaker unify-database

Note: In Linux/UNIX it is necessary to specify the current directory with ./ :

./processmaker unify-database

For example, to merge the databases for all the workspaces on a Windows Vista/7/8/10/Server 2008/2012 server:

cd C:\Users\USERNAME\AppData\Roaming\ProcessMaker-X_X_X\processmaker processmaker unify-database

To unify the databases of a specific workspace, issue the command:

processmaker unify-database WORKSPACE
For example, to merge the default "workflow" workspace in a Linux/UNIX server, login as the root user (or use sudo -i) and issue the following commands:

cd /opt/processmaker
./processmaker unify-database workflow

Note: This command should be run after upgrading ProcessMaker to version 2.8 or later. See Step 2 in upgrading ProcessMaker.