Combination View Flat View Tree View
Threads [ Previous | Next ]
alexey -bykov
how to change RDBMS HSQLDB to MySQL?
November 6, 2012 8:00 PM
Answer

alexey -bykov

Rank: New Member

Posts: 22

Join Date: November 6, 2012

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
Paul Robinson
RE: how to change RDBMS HSQLDB to MySQL?
November 6, 2012 8:30 PM
Answer

Paul Robinson

Rank: Junior Member

Posts: 45

Join Date: December 29, 2008

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
alexey -bykov
RE: how to change RDBMS HSQLDB to MySQL?
November 6, 2012 8:44 PM
Answer

alexey -bykov

Rank: New Member

Posts: 22

Join Date: November 6, 2012

Recent Posts

Hi, Paul!

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

Thank you,emoticon
ivanov-void
Priyanka Dhingra
RE: how to change RDBMS HSQLDB to MySQL?
November 6, 2012 10:16 PM
Answer

Priyanka Dhingra

Rank: Liferay Master

Posts: 501

Join Date: December 19, 2011

Recent Posts

This is a very common question....Better next time if you could google before you post the thread
alexey -bykov
RE: how to change RDBMS HSQLDB to MySQL?
November 6, 2012 11:50 PM
Answer

alexey -bykov

Rank: New Member

Posts: 22

Join Date: November 6, 2012

Recent Posts

Hi, Priyanka Dhingra!

Well, I'll know. Thank you!