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.
我有Liferay 6.2。它在hsql中有一些数据。我需要将这些数据导入mysql数据库。如何将所有数据从hsql导入到mySQL。
I am having following files in data/hsql folder lportal.lck (lck file) lportal (seems like data base dump) lportal.properties lportal.script
我在data / hsql文件夹中有以下文件lportal.lck（lck file）lportal（看起来像数据库转储）lportal.properties lportal.script
Is there any way to import db using some script or changing some configuration files.
有没有办法使用某些脚本或更改某些配置文件导入数据库。
1 个解决方案
#1
2
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用户指南并滚动到数据迁移部分，其中一些相关部分转载如下：
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.
第一部分允许您将整个Liferay数据库从运行它的当前数据库复制到您在此字段集中指定的数据库。您需要输入驱动程序类名称（驱动程序需要在Liferay的类路径中），您要复制数据的数据库的JDBC URL以及有权访问该数据库的用户的凭据。输入所有这些信息后，单击“执行”以复制数据。
Go to Control Panel → Server Administration → Data Migration Tab → Enter the jdbc property of the mysql database → Execute
转到控制面板→服务器管理→数据迁移选项卡→输入mysql数据库的jdbc属性→执行
After this shut-down your server and update your portal-ext.properties to point to the new mysql database and restart your server. Done!
关闭服务器并更新portal-ext.properties以指向新的mysql数据库并重新启动服务器之后。完成！
#1
2
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用户指南并滚动到数据迁移部分，其中一些相关部分转载如下：
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.
第一部分允许您将整个Liferay数据库从运行它的当前数据库复制到您在此字段集中指定的数据库。您需要输入驱动程序类名称（驱动程序需要在Liferay的类路径中），您要复制数据的数据库的JDBC URL以及有权访问该数据库的用户的凭据。输入所有这些信息后，单击“执行”以复制数据。
Go to Control Panel → Server Administration → Data Migration Tab → Enter the jdbc property of the mysql database → Execute
转到控制面板→服务器管理→数据迁移选项卡→输入mysql数据库的jdbc属性→执行
After this shut-down your server and update your portal-ext.properties to point to the new mysql database and restart your server. Done!
关闭服务器并更新portal-ext.properties以指向新的mysql数据库并重新启动服务器之后。完成！