HSQL to MySql not working

[John Smith, geändert vor 12 Jahren.]

I was able to insert all records from my hsql database.
however when the page loads i see my Pages but there is NO content on any of the pages.
also when i click the sign in link nothing happens.

Any other documentation to help diagnose this problem?

Thanks
bg



in addition below needed to modify the dates for mysql.

// from http://www.liferay.com/web/guest/community/wiki/-/wiki/Main/Database%20Configuration
To recap the HSQL - MySQL process:
(1) Go into the folder C:\liferay-portal-5.2.2\tomcat-5.5.27\webapps\ROOT\WEB-INF\classes\
(2) Create a file: portal-ext.properties
(3) add this content to this file:
schema.run.enabled=true
schema.run.minimal=true
jdbc.default.driverClassName=­com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/lportal?useUnicode=­true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.default.username=lport­al
jdbc.default.password=thepassword
(4) Create an empty database called lportal
(5) Start liferay. This will populate the database with all the tables (147) and insert data into them.
(6) Empty the data. This can be done by selecting all the tables in phpmyadmin and selecting "Empty" from the dropdown.
(7) Open the file C:\liferay-portal-5.2.2\data\hsql\lportal.script and find the first INSERT statment.
(8) Select from here on down to the end of the file and copy/paste this into a new file.
(9) Add a semicolon to the end of each insert statement. This can be done by search&replace close-parens followed by CR with close-parens semicolon CR -- ')CR' with ');^p' (^p is the ultraedit symbol for CR)
(10) import this into MySQL into the emptied database.

[John Smith, geändert vor 12 Jahren.]

Well I tried the Liferay data migration via the Server Administration.
This time it worked. First time it did not seem to.
So then I went to the manual method which did not work.

But it works now.

bg