Message Boards

how to change RDBMS HSQLDB to MySQL?

ivanov -void, modified 11 Years ago.

how to change RDBMS HSQLDB to MySQL?

New Member Posts: 22 Join Date: 11/7/12 Recent Posts
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! emoticon
thumbnail
Paul Robinson, modified 11 Years ago.

RE: how to change RDBMS HSQLDB to MySQL? (Answer)

Junior Member Posts: 46 Join Date: 12/30/08 Recent Posts
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, modified 11 Years ago.

RE: how to change RDBMS HSQLDB to MySQL?

New Member Posts: 22 Join Date: 11/7/12 Recent Posts
Hi, Paul!

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

Thank you,emoticon
ivanov-void
thumbnail
Priyanka Dhingra, modified 11 Years ago.

RE: how to change RDBMS HSQLDB to MySQL?

Liferay Master Posts: 501 Join Date: 12/20/11 Recent Posts
This is a very common question....Better next time if you could google before you post the thread
ivanov -void, modified 11 Years ago.

RE: how to change RDBMS HSQLDB to MySQL?

New Member Posts: 22 Join Date: 11/7/12 Recent Posts
Hi, Priyanka Dhingra!

Well, I'll know. Thank you!