Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Ishan Sahore
Mysql database population commands
July 23, 2012 2:08 AM
Answer

Ishan Sahore

Rank: Junior Member

Posts: 56

Join Date: April 25, 2012

Recent Posts

Hi all,

I want to know where are all the sql commands(queries) stored in liferay when we configure it for using MySQL by which default tables and data get populated into the database 'lportal'. I want to make it able to store web content in Multiple languages ,e.g. hindi. For this I need to modify the database and table creation commands in it.

Any help is appreciated.


Thanks,
Ishan Sahore
Debasis Padhi
RE: Mysql database population commands
July 23, 2012 2:35 AM
Answer

Debasis Padhi

Rank: Junior Member

Posts: 55

Join Date: March 23, 2012

Recent Posts

Configure the data base details In side /tomcat-7.0.23/webapps/ROOT/WEB-INF/classes/ portal-ext.properties

If you want to prepare a portlet for language then You can use the existing Language portlet
By Hook you can also customize this
Jignesh Vachhani
RE: Mysql database population commands
July 23, 2012 3:07 AM
Answer

Jignesh Vachhani

Rank: Liferay Master

Posts: 785

Join Date: March 10, 2008

Recent Posts

Hi Ishan,

I am not sure from where exact it's getting populated.But you can find sql folder in portal source.
And there we will have 2 .sql files portal-tables.sql and portal-data-common.sql exist which could be included in some dependency jar i think.
I am not sure which jar its referring.
Priyanka Dhingra
RE: Mysql database population commands
July 23, 2012 4:50 AM
Answer

Priyanka Dhingra

Rank: Liferay Master

Posts: 501

Join Date: December 19, 2011

Recent Posts

hi,
check this
Creating the database and tables #

 1You will first need to create the database, make sure that this matches the value in the url of your ROOT.xml.
 2
 3For most versions of Liferay, you will have 2 sets of sql scripts, one which will create the Liferay tables with sample data (the Liferay public website) or with just the bare minimal data. You can find both sets of scripts in the portal code:
 4
 5portal\sql\portal\portal-mysql.sql
 6
 7and
 8
 9portal\sql\portal-minimal\portal-minimal-mysql.sql
10
11If you..
12
13    dont have the portal source code,
14        you can download all the scripts online here: http://www.liferay.com/web/guest/downloads/additional or http://sourceforge.net/projects/lportal and download the portal SQL scripts.
15    dont see the scripts in source,
16        you will have to run "ant start" from your portal source folder which will generate the appropriate files.

http://www.liferay.com/community/wiki/-/wiki/Main/Database+Configuration
Wieteke den Uijl
RE: Mysql database population commands
July 23, 2012 5:22 AM
Answer

Wieteke den Uijl

Rank: Junior Member

Posts: 55

Join Date: April 19, 2011

Recent Posts

Hi Ishan,

Any chance you can move these forum conversations to another part of the Liferay Forum. You're currently posting in the Dutch forum about the Dutch Liferay Community and although your questions are interesting they have very little to do with the Netherlands or the Liferay community there. Thanks!

Regards,
Wieteke