找回密码
 注册成为天翎用户
查看: 569|回复: 1

[已解决] Mysql数据库中文表名如何进行备份恢复

[复制链接]
celina 发表于 2021-7-30 18:19:34 | 显示全部楼层 |阅读模式
【myApps/OBPM版本号】:v4.4- sp XX
【浏览器类型】:Chrome/其他
【联系方式-QQ】:QQ号码
【联系电话】:    联系电话
【问题描述】:Mysql数据库中文表名如何进行备份恢复









1、问题描述最好图文并茂,如有视频/脚本可直接放出,这样技术同事在处理该问题时效率更加高效哦~
2、如果该问题已得到解决,请在该帖子下回复\"已解决可结帖\"
 楼主| celina 发表于 2021-7-30 18:20:11 | 显示全部楼层
用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_专家首页`表不能导入库中
回复

使用道具 举报

本版积分规则

手机版|天翎MyApps技术社区 ( 粤ICP备11093750号 )

GMT+8, 2026-8-15 04:54

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

快速回复 返回顶部 返回列表