Liferay Migration form 5.2.3 to 6.2

Liferay Migration from 5.2.3. to 6.2

Step 1. Migration to 6.0.6

1. Create 5.2.3 DB dump (db.sql).

2. Create database for LR 6.0.6 (db606).

3. Load 5.2.3 dump into 6.0.6 database:

mysql -uroot -p1 db606 < db.sql;

Delete all database views (if any).

4. Unzip clean Liferay 6.0.6.

5. Delete all folders from 'webapps' (except 'ROOT' and 'tunnel-web'); delete jre from tomcat folder.

6. Copy 'data' folder from Liferay 5.2.3 to Liferay 6.0.6.

7. Startup Liferay 6.0.6 (with default Hypersonic database settings).

8. Shutdown Liferay 6.0.6.

9. Create portal-ext.properties file:

jdbc.default.driverClassName=com.mysql.jdbc.Driver

jdbc.default.url=jdbc:mysql://localhost:3306/db606?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false

jdbc.default.username=root

jdbc.default.password=1

permissions.user.check.algorithm=5

image.hook.impl=com.liferay.portal.image.DatabaseHook

10. Startup Liferay 6.0.6. Wait until Liferay's upgrade process has upgraded database to 6.0.6.

11. Go to Control Panel → Server Administration → Data Migration. Click 'Execute' under 'Convert legacy permission algorithm'.

12. Once permission algorithm is upgraded, remove permissions.user.check.algorithm property

from portal-ext.properties file and restart server.

13. Go to Control Panel → Server Administration → Data Migration. Select 'FileSystemHook' inside Migrate images section, and click 'Execute' button.

14. Change image.hook.impl to com.liferay.portal.image.FileSystemHook in portal-ext.properties file and restart server.

15. Go to Control Panel → Server Administration → Data Migration. Select 'AdvancedFileSystemHook' inside Migrate documents section, and click 'Execute' button.

16. add
dl.hook.impl=com.liferay.documentlibrary.util.AdvancedFileSystemHook

Step 2. Migration to 6.1.

1. Create 6.0.6 DB dump (db606.sql).

2. Create database for LR 6.1 (db61).

3. Load 6.0.6 dump into 6.1 database:

mysql -uroot -p1 db61 < db606.sql;

Check if there is no " ' " symbol in organization_.name DB field.

4. Unzip clean Liferay 6.1.

5. Startup Liferay 6.1 (with default Hypersonic database settings).

6. Shutdown Liferay 6.1.

7. Copy 'data' folder from Liferay 6.0.6 to Liferay 6.1.

8. Create portal-ext.properties file:

jdbc.default.driverClassName=com.mysql.jdbc.Driver

jdbc.default.url=jdbc:mysql://localhost:3306/db61?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false

jdbc.default.username=root

jdbc.default.password=1

dl.hook.impl=com.liferay.documentlibrary.util.AdvancedFileSystemHook
dl.store.impl=com.liferay.portlet.documentlibrary.store.AdvancedFileSystemStore

9. Startup Liferay 6.1. Wait until Liferay's upgrade process has upgraded database to 6.1.

Step 3. Migration to 6.2.

1. Create 6.1 DB dump (db61.sql).

2. Create database for LR 6.2 (db62).

3. Load 6.1 dump into 6.2 database:

mysql -uroot -p1 db62 < db61.sql;

Check if there is no " ' " symbol in organization_.name DB field.

4. Unzip clean Liferay 6.2.

5. Startup Liferay 6.2 (with default Hypersonic database settings).

6. Shutdown Liferay 6.2.

7. Copy 'data' folder from Liferay 6.1 to Liferay 6.2.

8. Modify portal-setup-wizard.properties file, add db configuration:

jdbc.default.driverClassName=com.mysql.jdbc.Driver

jdbc.default.url=jdbc:mysql://localhost:3306/db62?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false

jdbc.default.username=root

jdbc.default.password=1

dl.hook.impl=com.liferay.documentlibrary.util.AdvancedFileSystemHook
dl.store.impl=com.liferay.portlet.documentlibrary.store.AdvancedFileSystemStore

passwords.encryption.algorithm.legacy=SHA

9. Startup Liferay 6.2. Wait until Liferay's upgrade process has upgraded database to 6.2.

Step 4. Portlets and Themes Migration.

4.1. Migrate portlets from 5.2.3 to 6.2 version.

4.2. Migrate themes from 5.2.3 to 6.2 version. Make sure, that themeId is the same in 5.2.3 and 6.2 versions, otherwise themes will be not applied for pages.

copied from 

http://vetal-liferay.blogspot.com/2014/01/liferay-migration-form-523-to-62.html