O2OA数据迁移

Ray

数据迁移:
在原服务器控制台窗口下输入命令:
dump data password
此命令将会把数据库中所有数据导出成文本形式.并保存在local/dump目录下,以时间戳命名,如dumpData_20190320142228
将此目录手工复制到目标服务器的local/dump目录下
在目标服务器控制台窗口下输入命令:
restore data 20190320142228 password
将把dumpData_20190320142228目录中所有数据重新写入目标服务器数据库.

yang

你好，请问我从H2数据库迁移到MySQL5.7 报了个错
<openjpa-3.0.1-SNAPSHOT-rb714dbae1876957a56133ff2aebb5d84919af79e nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Too-big precision 32 specified for 'xlastReportTime'. Maximum is 6. {      stmnt 2137790157 CREATE TABLE OKR_WORKBASEINFO (xid VARCHAR(64) NOT NULL, xcreateTime DATETIME(6), xscratchBoolean BIT, xscratchDate DATETIME(6), xscratchInteger DATETIME(6), xscratchString VARCHAR(255), xsequence VARCHAR(128), xupdateTime DATETIME(6), xdistributeFactor INTEGER, xappraiseTimes INTEGER, xarchiveDate DATETIME(6), xcenterId VARCHAR(64), xcenterTitle VARCHAR(255), xcompleteDateLimit DATETIME(6), xcompleteDateLimitStr VARCHAR(32), xcompleteTime DATETIME(6), xconfirmDateStr VARCHAR(32), xcreatorIdentity VARCHAR(255), xcreatorName VARCHAR(255), xcreatorTopUnitName VARCHAR(255),xcreatorUnitName VARCHAR(255), xcurrentActivityName VARCHAR(32), xcurrentAppraiseInfoId VARCHAR(64), xcurrentAppraiseJobId VARCHAR(64), xcurrentAppraiseStatus VARCHAR(32), xcurrentAppraiseTitle VARCHAR(255), xcurrentAppraiseWorkId VARCHAR(64), xdeployDateStr VARCHAR(32), xdeployMonth VARCHAR(16), xdeployYear VARCHAR(16), xdeployerIdentity VARCHAR(255), xdeployerName VARCHAR(255), xdeployerTopUnitName VARCHAR(255), xdeployerUnitName VARCHAR(255), xisCompleted BIT, xisNeedReport BIT, xisOverTime BIT, xlastReportTime DATETIME(32), xnextReportTime DATETIME(32), xoverallProgress INTEGER, xparentWorkId VARCHAR(64), xparentWorkTitle VARCHAR(255), xprogressAnalyseTime VARCHAR(32), xreportAdminIdentity VARCHAR(255), xreportAdminName VARCHAR(255), xreportCount INTEGER, xreportCycle VARCHAR(32), xreportDayInCycle INTEGER, xreportNeedAdminAudit BIT, xreportTimeQue LONGTEXT, xresponsibilityEmployeeName VARCHAR(255), xresponsibilityIdentity VARCHAR(255), xresponsibilityTopUnitName VARCHAR(255), xresponsibilityUnitName VARCHAR(255), xshortDutyDescription VARCHAR(255), xshortLandmarkDescription VARCHAR(255), xshortMajorIssuesDescription VARCHAR(255), xshortProgressAction VARCHAR(255), xshortProgressPlan VARCHAR(255), xshortResultDescription VARCHAR(255), xshortWorkDetail VARCHAR(255), xstatus VARCHAR(16), xtitle VARCHAR(255), xworkAuditLevel INTEGER, xworkDateTimeType VARCHAR(16), xworkLevel VARCHAR(32), xworkProcessStatus VARCHAR(16), xworkType VARCHAR(32), UNIQUE OKR_WORKBASEINFO_DUC (xid, xcreateTime, xupdateTime, xsequence)) ENGINE = innodb} [code=1426, state=42000]
这个要怎么解决呢？

yang

这个密码是哪个密码？
是xadmin的密码吗

论坛管理员

您好。先检查一下您的的mysql的 TIMESTAMP和DATETIME 默认设置是什么样的。初步判断，mysql默认的时间或者时间戳的格式，和h2的一致。

论坛管理员

是的xadmin的密码。如果您没有修改过，默认应该是 “o2”

论坛管理员

您好：
不同额版本不一样，请看文档
https://www.yuque.com/o2oa/course/ozgbcv