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.
processmaker unify-database command is available in version 2.8.0 and later to merge the three databases per workspace into one database.
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:
Note: In Linux/UNIX it is necessary to specify the current directory with
For example, to merge the databases for all the workspaces on a Windows Vista/7/8/10/Server 2008/2012 server:
To unify the databases of a specific workspace, issue the command:
sudo -i) and issue the following commands:
./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.