Liferay 6.x database reset

I came across an issue that made me start looking for a Liferay database reset. It turned out to be pretty simple, but it was not that easy to find

So here is what to do when you are using your hypersonic default database:

• Stop your liferay application
• Go to ${LIFERAY_HOME}/data/hsql folder
• Remove your liferay.script and lportal.properties from that folder

And if you have already configured your Liferay to use Mysql or whatever other database, than just remove and recreate your custom liferay database again.

• drop database lportal;
• create database lportal character set utf8;