天翎MyApps技术社区 - 低代码平台 | 流程管理系统 | BPM软件

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

Mysql数据库中文表名如何进行备份恢复

[复制链接]
cynthia_84 发表于 2010-10-15 16:04:19 | 显示全部楼层 |阅读模式
Mysql数据库好像不支持中文表名,将obpm数据库备份之后再在mysql中恢复的话,会出错,请问这个问题怎么解决啊?
 楼主| cynthia_84 发表于 2010-10-15 16:23:08 | 显示全部楼层
用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_专家首页`表不能导入库中
 楼主| cynthia_84 发表于 2010-10-15 16:42:50 | 显示全部楼层
是的,使用的character_set用的是utf8
 楼主| cynthia_84 发表于 2010-10-15 16:43:19 | 显示全部楼层
所有的character_set都设置的utf8
 楼主| cynthia_84 发表于 2010-10-15 16:57:48 | 显示全部楼层
因为机器上装了mysql,myapps的mysql是绿色的,运行会把安装的mysql服务覆盖掉,换来换去麻烦,想把它放到安装版的mysql中,直接copy data文件夹的话不行,备份恢复就出错了

本版积分规则

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

GMT+8, 2026-8-12 10:22

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

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