Liferay diaries: Changing virtual host for a community backup

Once in a while one has to replicate an entire Liferay installation locally. The easy way is to export the database from the source machine and import it to the target machine, which in my case usually revolves around importing a production setting to my developer machine.

The import should work flawlessly, one just has to change the virtual host:

update Company set virtualhost="portal.localhost" where webid="productio.server.com";