Liferay Database upgrade from 6.0.5 to 6.1.1

STEP 1:

 Take the back up of all files related to 6.0.5

 

Before starting the upgrade Login as administrator in 6.0.5 and navigate to the Control Panel. Go to Server Administration and select Data Migration from the menu along the top of the screen. A section entitled Legacy Permissions Migration appears at the bottom of the page.

 

Tick the check box. And execute.

This will upgrade algorithm 5 to 6.

Now change the algorithm to 6 in portal-ext.properties and restart the server, check the permissions.

Note: the process time to execute permission algorithm may take 2 to 4 hours based on your system performance. All the above process is done in 6.0.5.

STEP 2: 

• Download and extract the 6.1.1 ce ga2 tomcat distribution.
•  Goto liferaytomcat 6.1.1->tomcat7->bin->setnev.sh Edit the file keep the heap size as
  2048M(Optional).
•  Copy the Portal-ext.properties file from 6.0.5 to 6.1.1.
• In the Properties file chage the  permissions.user.check.algorithm from 5 to 6 and also check the other properties that are available in 6.1.1.
• Make sure liferay.home points to your (new) distribution, verify schema name, verify username password of your database.
• Copy the existing 6.0.5 ${liferay.home}/data directory to the 6.1 ${liferay.home} directory
•  Now start the Liferay 6.1 server and see the log that upgrade process will run for adding,updating the tables and also getting some db warning and errors at the first time only.

 NOTE:If any error comes during the upgrade process stop the server drop the current database and reload DB which you have taken back up and re do the above steps untill upgradation finished with out errors.