• Sharebar

Overview

Follow these instructions to migrate the data from a Windows installation of ProcessMaker to a Linux/UNIX installation of ProcessMaker. All the data in a workspace (processes, users, cases, etc) can be migrated from a Linux/UNIX installation to a Windows installation of ProcessMaker without any problems, however, table names cause problems when migrating workspaces from Windows to Linux/UNIX. MySQL in Windows is case insensitive, whereas MySQL is case sensitive in Linux/UNIX by default. When data from MySQL in Windows is imported into Linux/UNIX, the ProcessMaker tables names will be in lowercase, while the ProcessMaker code expects them to be in uppercase. This incompatibility can be worked around either by changing the MySQL configuration or by running a script to rename the tables in the ProcessMaker databases.

Warning: Make sure that both installations are using the SAME version of ProcessMaker. Data from one version of ProcessMaker should not be used in a different version of Processmaker due to incompatibilities between database structure and code. If needing to move between versions, first upgrade the Windows installation of ProcessMaker to the same version of ProcessMaker which is installed in Linux/UNIX. Then follow these instructions.

Backing up ProcessMaker Databases on Windows

Run the following command to back up wf_workflow, rb_workflow and rp_workflow databases:

mysqldump -u USERNAME -p -F -x –databases wf_workflow rb_workflow rpworkflow > BACKUP-FILE.sql

Backing up ProcessMaker workspace on Windows

First, follow these instructions to use the processmaker workspace-backup command to backup the ProcessMaker workspaces in Windows. Then, copy the workspace backup files to the Linux server where the same version of ProcessMaker is also installed.

Restoring ProcessMaker workspace on Linux

Go to the Linux server and use the processmaker workspace-restore> command to restore the workspace(s) in that installation of ProcessMaker.

Deleting ProcessMaker Databases

Delete the 3 databases of ProcessMaker in mysql with the next command:

drop database name_database

Table names problems in MySQL

When the ProcessMaker workspaces from Windows are restored into Linux, the table names of the workspace databases will be in lowercase. ProcessMaker will not be able to read these tables correctly because it expects the table names to be in uppercase. To work around this problem, either configure MySQL tables to be case insensitive or change the name of the tables of the backup to upper-case with a text editor.

Configuring MySQL Tables to be Case Insensitive

Go the Linux/UNIX server and edit the MySQL configuration file, which is generally found at /etc/mysql/my.cnf, /etc/my.cnf or ~/my.cnf

Add the following line to the my.cnf configuration file:

lower_case_table_names=1

Then restart MySQL (or reboot):

Debian/Ubuntu/SuSE:

/etc/init.d/mysql restart

Red Hat/CentOS/Fedora:

/etc/init.d/mysqld restart

Restoring ProcessMaker Databases on Linux

Run the following command to restore Databases:

mysql -u root – < name_backup.sql

Changing the rp_workflow database name

Change the rp_workflow database name by executing the following command:

mysqldump -u user -password rpworkflow | mysql -u user -'password rp_workflow

Finally run the processmaker upgrade command:

php-f processmaker upgrade