|
|
用MySQLAdministrator.exe备份obpm数据库为sql文本,然后再在本机上讲备份的sql文本用MySQLAdministrator.exe恢复,就是简单的操作。会有类似这样的问题:
Warning: Do not know how to handle this statement at line 28:
CREATE TABLE `auth_专家首页` (
`ID` varchar(200) NOT NULL,
`DOC_ID` varchar(200) DEFAULT NULL,
`VALUE` varchar(200) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 39:
/*!40000 ALTER TABLE `auth_专家首页` DISABLE KEYS */;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
Warning: Do not know how to handle this statement at line 40:
/*!40000 ALTER TABLE `auth_专家首页` ENABLE KEYS */;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.
然后`auth_专家首页`表不能导入库中 |
|