Migration liferay-6.0.6 to liferay6.2

To migrate liferay 6.0.6 to liferay 6.2 we need to follow below steps.

Step 1. First we need to migrate liferay-6.0.6 to liferay-6.1.

1. Create 6.0.6 Database dump like (macsiv.sql).
2. Create database for liferay-6.1 (macsiv6.1).
3. Load liferay-6.0.6 dump into liferay-6.1 database for this use below command
   mysql -uroot -p1 macsiv6.1 < macsiv.sql;
4. Download and Unzip clean Liferay 6.1.
5. Start Liferay-6.1 with default Hypersonic database settings.
6. Shutdown or stop Liferay 6.1.
7. Now copy 'data' folder from Liferay-6.0.6 to Liferay-6.1.0.
8. Create one portal-ext.properties in class folder and pest below contents:

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

jdbc.default.url=jdbc:mysql://localhost:3306/macsiv6.1?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.default.username=root
jdbc.default.password=root

dl.hook.impl=com.liferay.documentlibrary.util.AdvancedFileSystemHook
dl.store.impl=com.liferay.portlet.documentlibrary.store.AdvancedFileSystemStore
   
   9. Now start Liferay-6.1. and wait until liferay's upgrade process has upgraded database to 6.1.

Step 2. Now migratie liferay6.1 to liferay-6.2.

1. Create dump of liferay6.1 (macsiv1.sql).
2. Create new database for liferay-6.2 (macsiv16.2).
3. Load liferay-6.1 dump into liferay-6.2 database for this use below command:
   mysql -uroot -p1 macsiv16.2 < ttune1.sql;
4. New download and unzip clean Liferay-6.2.
5. Start Liferay-6.2 with default Hypersonic database settings.
6. Shutdown or stop Liferay 6.2.
7. Now copy 'data' folder from Liferay-6.1.0 to Liferay-6.2.0.
8. Modify portal-setup-wizard.properties file, add db configuration:

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

jdbc.default.url=jdbc:mysql://localhost:3306/macsiv16.2?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.default.username=root
jdbc.default.password=root

dl.hook.impl=com.liferay.documentlibrary.util.AdvancedFileSystemHook
dl.store.impl=com.liferay.portlet.documentlibrary.store.AdvancedFileSystemStore
passwords.encryption.algorithm.legacy=SHA

   9.  Start Liferay-6.2. Wait until liferay upgrade process has upgraded database to liferay-6.2.