Kombinierte Ansicht Flache Ansicht Baumansicht
Threads [ Zurück | Nächste ]
toggle
alexey -bykov
how to change RDBMS HSQLDB to MySQL?
6. November 2012 20:00
Antwort

alexey -bykov

Rang: New Member

Nachrichten: 22

Eintrittsdatum: 6. November 2012

Neue Beiträge

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?
6. November 2012 20:30
Antwort

Paul Robinson

Rang: Junior Member

Nachrichten: 45

Eintrittsdatum: 29. Dezember 2008

Neue Beiträge

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?
6. November 2012 20:44
Antwort

alexey -bykov

Rang: New Member

Nachrichten: 22

Eintrittsdatum: 6. November 2012

Neue Beiträge

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?
6. November 2012 22:16
Antwort

Priyanka Dhingra

Rang: Liferay Master

Nachrichten: 501

Eintrittsdatum: 19. Dezember 2011

Neue Beiträge

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?
6. November 2012 23:50
Antwort

alexey -bykov

Rang: New Member

Nachrichten: 22

Eintrittsdatum: 6. November 2012

Neue Beiträge

Hi, Priyanka Dhingra!

Well, I'll know. Thank you!