Foren
how to change RDBMS HSQLDB to MySQL?
ivanov -void, geändert vor 11 Jahren.
how to change RDBMS HSQLDB to MySQL?
New Member Beiträge: 22 Beitrittsdatum: 07.11.12 Neueste 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!
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.
RE: how to change RDBMS HSQLDB to MySQL? (Antwort)
Junior Member Beiträge: 46 Beitrittsdatum: 30.12.08 Neueste 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
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.
RE: how to change RDBMS HSQLDB to MySQL?
New Member Beiträge: 22 Beitrittsdatum: 07.11.12 Neueste Beiträge
Hi, Paul!
Thank you! This is exactly what I need, just change the database.
Thank you,
ivanov-void
Thank you! This is exactly what I need, just change the database.
Thank you,
ivanov-void
Priyanka Dhingra, geändert vor 11 Jahren.
RE: how to change RDBMS HSQLDB to MySQL?
Liferay Master Beiträge: 501 Beitrittsdatum: 20.12.11 Neueste Beiträge
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.
RE: how to change RDBMS HSQLDB to MySQL?
New Member Beiträge: 22 Beitrittsdatum: 07.11.12 Neueste Beiträge
Hi, Priyanka Dhingra!
Well, I'll know. Thank you!
Well, I'll know. Thank you!