Where the internal database of Liferay is located?

[Tapas Mandal, geändert vor 11 Jahren.]

I am using liferay 6.1 EE and I need to access Liferay's internal database, but I am not sure where it is actually located. I guess it is in '\data\hsql\lportal.script'. Could somebody please clarify? Thanks.

[Octavio Sánchez, geändert vor 11 Jahren.]

Yes, this is the file where it's located.

I recommend you to configure the datasource of liferay to use MySQL if you want to make queries, (hsql is just a plain text file not query friendly).