liferay将数据从hsql迁移到mysql [英] liferay migrate data from hsql to mysql

问题描述

我正在使用Liferay 6.2.它在hsql中有一些数据.我需要将这些数据导入mysql数据库. 如何将所有数据从hsql导入mySQL.

I am having Liferay 6.2. It has some data in hsql. I need to import these data into mysql database. How can I import all data from hsql to mySQL.

我在data/hsql文件夹中有以下文件 lportal.lck(lck文件) lportal(好像是数据库转储) lportal.properties lportal.script

I am having following files in data/hsql folder lportal.lck (lck file) lportal (seems like data base dump) lportal.properties lportal.script

是否可以使用某些脚本或更改某些配置文件来导入数据库.

Is there any way to import db using some script or changing some configuration files.

推荐答案

一种方法是您可以尝试使用liferay提供的数据迁移工具，请查看

One way is you can try using the Data migration tool liferay provides, check out the Liferay User-guide and scroll to Data-migration section, some relevant part of it is reproduced below:

第一部分使您可以将整个Liferay数据库从运行它的当前数据库复制到在这组字段中指定的数据库.您需要输入驱动程序类名称(驱动程序必须在Liferay的类路径上)，要将数据复制到的数据库的JDBC URL以及有权访问该数据库的用户的凭据.输入所有这些信息后，单击执行"以复制数据.

The first section lets you copy your entire Liferay database from the current database under which it is running to the database you specify in this set of fields. You’ll need to enter the driver class name (and the driver will need to be on Liferay’s classpath), the JDBC URL of the database to which you’ll be copying your data and the credentials of a user with access to that database. Once you have all of this information entered, click Execute to copy the data.

转到控制面板→ 服务器管理→ 数据迁移标签→ Enter the jdbc property of the mysql database→ 执行

Go to Control Panel → Server Administration → Data Migration Tab → Enter the jdbc property of the mysql database → Execute

在关闭服务器后，更新您的portal-ext.properties以指向新的mysql数据库并重新启动服务器.完成！

After this shut-down your server and update your portal-ext.properties to point to the new mysql database and restart your server. Done!

这篇关于liferay将数据从hsql迁移到mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！