how to change RDBMS HSQLDB to MySQL?

[ivanov -void, geändert vor 11 Jahren.]

Hi,

I the beginner in this technology.
I'm interested in the question- how to change the data base offered by default (hsqldb) to MySQL?

I would be most grateful for the information!
Thank you!

[Paul Robinson, geändert vor 11 Jahren.]

Hi,

Are you looking to migrate data or just change the database your portal is using.

There are a couple of ways to configure your portal to use MYSQL, the easiest is to configure the data provider in your portal-ext.properties by adding the following and changing the values of the properties to match your database.

#
# MySQL
#
jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/lportal?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.default.username=
jdbc.default.password=

You can also take a look at the 6.0 admin guide: http://cdn.docs.liferay.com/portal/6.0/official/liferay-administrator-guide-6.0.pdf

See page 29 which talks about the portal-ext.properties file and MYSQL set up.

Thanks,
Paul

[ivanov -void, geändert vor 11 Jahren.]

Hi, Paul!

Thank you! This is exactly what I need, just change the database.

Thank you,
ivanov-void

[Priyanka Dhingra, geändert vor 11 Jahren.]

This is a very common question....Better next time if you could google before you post the thread

[ivanov -void, geändert vor 11 Jahren.]

Hi, Priyanka Dhingra!

Well, I'll know. Thank you!