Page 1 of 1

backup and restore database

Posted: Mon Feb 18, 2019 3:31 am
by Siriporn
How to backup database version 3.0.1.7 and restore to version 3.2.1?
for window server 2012

Re: backup and restore database

Posted: Mon Feb 18, 2019 11:25 pm
by amosbatto
To backup the databases, see:
https://wiki.processmaker.com/3.2/Upgra ... ocessMaker

If you want to upgrade from version 3.0.1.7 to version 3.2.1, then read:
Upgrading to ProcessMaker 3.2
ProcessMaker 3.2 Upgrade Plan
Best Practices when Upgrading

Re: backup and restore database

Posted: Wed Feb 20, 2019 12:51 am
by Siriporn
I see . If I want to upgrade from version 3.0.1.7 to version 3.2.1
I have to upgrade php 5.4 to 5.5 .
could you advise me. How to upgrade php 5.4 to 5.5
thank you very much.

Re: backup and restore database

Posted: Wed Feb 20, 2019 2:54 am
by ziadeh
Processmaker 3.2 you need php 5.6, to upgrade your php follow these steps:

For Ubuntu :
Code: Select all
sudo apt-get install software-properties-common
sudo add-apt-repository ppa:ondrej/php
sudo apt-get update
sudo apt-get install apache2 mysql-server php5.6 php5.6-mbstring php5.6-mcrypt php5.6-mysql php5.6-xml php5.6-gd php5.6-ldap php5.6-curl php5.6-cli php5.6-soap
After that you need to enable the new version of the php
Code: Select all
sudo a2dismod php5.4
sudo a2enmod php5.6
sudo service apache2 restart

Step 2:
Code: Select all
sudo nano /etc/php/5.6/apache2/php.ini
Search for the following lines and edit them using the following configurations:
file_uploads = On
short_open_tag = On
memory_limit = 512M
error_reporting = E_ALL & ~E_DEPRECATED & ~E_STRICT
display_errors = Off
post_max_size = 24M
upload_max_filesize = 24M

It is also recommended to set the date.timezone to a your time zone as shown below:
date.timezone = Asia/Istanbul
Then
Code: Select all
sudo service apache2 restart

Re: backup and restore database

Posted: Wed Feb 20, 2019 10:20 pm
by chanatsamon
Hi,

I see. How to upgrade PHP 5.4 to 5.6 for window ?
https://wiki.processmaker.com/3.2/Upgra ... ocessMaker
Requirements
1.See the requirements for ProcessMaker 3.2.
2.ProcessMaker version 3.2 or later requires PHP 5.6 in Linux and PHP 5.5 in Windows.
3.If using an older version of PHP, make sure to upgrade PHP before upgrading ProcessMaker.

Re: backup and restore database

Posted: Wed Feb 20, 2019 10:29 pm
by amosbatto
Are you using a manual install of ProcessMaker in Windows?
I recommend just upgrading to version 3.2.1, so you don't have change your version of PHP.

If you want to upgrade, then see:
https://www.pmusers.com/index.php/Upgra ... in_Windows

If you have a Bitnami installation, then you will need to do a new manual installation of a recent version of ProcessMaker and then transfer the database and files over to the manual installation. See:
https://www.pmusers.com/index.php/Migra ... al_install

There are number of bugs, that you may want to fix in the source code, if you are going to use recent versions of the Community Edition. See:
https://www.pmusers.com/index.php/Bugs_ ... _upgrading

Re: backup and restore database

Posted: Wed Feb 20, 2019 10:45 pm
by chanatsamon
Hi Amos,

I want upgrade Processmaker 3.0.1.7 to 3.2.1.
But I can't upgrade PHP 5.4 to 5.6 for windows.
Can you suggest a way to upgrade PHP before upgrading Processmaker?

Re: backup and restore database

Posted: Thu Feb 21, 2019 4:12 pm
by amosbatto
chanatsamon wrote: I want upgrade Processmaker 3.0.1.7 to 3.2.1.
But I can't upgrade PHP 5.4 to 5.6 for windows.
Can you suggest a way to upgrade PHP before upgrading Processmaker?
If you have a manual install in Windows and want to upgrade from PHP 5.4 to PHP 5.6, then see these instructions:
https://www.pmusers.com/index.php/Upgra ... in_Windows

If you have a Bitnami installation, then you will need to do a new manual installation of a recent version of ProcessMaker and then transfer the database and files over to the manual installation. See:
https://www.pmusers.com/index.php/Migra ... al_install

Re: backup and restore database

Posted: Sun Feb 24, 2019 7:11 am
by chanatsamon
Hi Amos,

I choose to do item 2.
https://www.pmusers.com/index.php/Migra ... al_install

By trying 2 types.
1. I have version 3.0.1.7 by install from ProcessMaker-3.0.1.7-community-Setup.exe and have version 3.2.1 by Bitnami install
MySql = ฺBackup database no problem.
Processmaker = not working.

2. I manually installed version 3.2.1
I follow the steps listed below to prepare the environment before installing ProcessMaker already done.
https://wiki.processmaker.com/3.0/Stack_210

And install ProcessMaker 3.2.1.
I followed each step till step 4 using this wikia.
https://wiki.processmaker.com/3.0/Windo ... stallation

Now I try to install it on my personal computer. Before installing at the server again.
Which method is better?

Re: backup and restore database

Posted: Sun Feb 24, 2019 10:13 pm
by chanatsamon
Hi,

I checked the server, I can't use the manual installation method. Because I have other programs running.
Can I use the method you recommend?

Re: backup and restore database

Posted: Mon Feb 25, 2019 2:57 am
by TedShelton
I am trying to test Windows Server 2012 Backup option. I am backing up on a network share. While creating the backup schedule it gave me an error "The user name being used for accessing the remote share folder is not recognising by the local computer"

Re: backup and restore database

Posted: Wed Feb 27, 2019 3:32 am
by evabrown
I am also facing the same issue on my device. It was happening after updating the OS to Windows 10 and showing Windows 10 Preparing Automatic Repair Error. As I am new in the OS I haven't proper ideas about it. If you have any idea please share.