Migrate Liferay 6 to Liferay 7 on MySQL

1- Do a copy of the backup

Modify the portal-ext.properties


redirect.url.security.mode=ip
redirect.url.domains.allowed=localhost,workcouncil.infosys.com
redirect.url.ips.allowed=127.0.0.1,privateIp,PublicIp,SERVER_IP

Resolve to your virtual host in etc/host


Modify the config of osgi
 vi osgi/configs/com.liferay.portal.workflow.kaleo.runtime.internal.notification.EmailNotificationSender.cfg

fromAddress=someone@yahoo.fr

2 - Change collation on columns
ALTER TABLE AssetCategory             CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE AssetEntry                CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE AssetVocabulary           CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE BlogsEntry                CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE BookmarksEntry            CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE BookmarksFolder           CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE CalEvent                  CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE Calendar                  CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE CalendarBooking           CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE CalendarResource          CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE DDLRecordSet              CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE DDMContent                CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE DDMDataProviderInstance   CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE DDMStructure              CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE DDMStructureVersion       CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE DDMTemplate               CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE DDMTemplateVersion        CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE DLFileEntry               CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE DLFileEntryType           CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE DLFileVersion             CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE DLFolder                  CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE ExportImportConfiguration CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE Group_                    CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE JournalArticle            CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE JournalFeed               CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE JournalFolder             CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE KaleoAction               CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE KaleoDefinition           CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE KaleoNode                 CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE KaleoNotification         CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE KaleoTask                 CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE KaleoTimer                CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE KaleoTransition           CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE Layout                    CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE LayoutBranch              CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE LayoutPrototype           CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE LayoutRevision            CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE LayoutSetBranch           CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE LayoutSetPrototype        CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE MBCategory                CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE MDRAction                 CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE MDRRule                   CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE MDRRuleGroup              CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE Marketplace_App           CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE PasswordPolicy            CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE PollsChoice               CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE PollsQuestion             CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE QUARTZ_JOB_DETAILS        CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE QUARTZ_TRIGGERS           CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE Repository                CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE Role_                     CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE ShoppingCategory          CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE ShoppingCoupon            CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE ShoppingItem              CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE ShoppingItemField         CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE ShoppingOrderItem         CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE SyncDLObject              CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE Team                      CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE UserGroup                 CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE UserIdMapper              CONVERT TO CHARACTER SET utf8 ;
ALTER TABLE WikiNode                  CONVERT TO CHARACTER SET utf8 ;