Discuz!官方免费开源建站系统

 找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索

[已解决] 遇到一个奇怪的问题。UC的member里面竟然丢失5万多用户。

[复制链接]
恒少少 发表于 2013-9-15 11:22:28 | 显示全部楼层 |阅读模式
遇到一个奇怪的问题。来咨询一下大家。今天在进行论坛数据转移工作。把数据库分离到一台专用的数据库服务器上面去。UC和论坛分别为两个数据库。论坛数据库正常备份移动过去了。一切正常。但是UC数据库备份移动到新的数据库服务器以后。出现导入错误
列出一部分
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'chat_users' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.chat_users' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.chat_users' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.chat_users' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_admins' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_admins' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_admins' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_admins' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_admins' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_applications' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_applications' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_applications' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_applications' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_applications' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_badwords' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_badwords' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_badwords' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_badwords' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_domains' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_domains' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_domains' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_domains' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_domains' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_failedlogins' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_failedlogins' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_failedlogins' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_failedlogins' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_failedlogins' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_feeds' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_feeds' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_feeds' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_feeds' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_feeds' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_feeds' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_friends' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_friends' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_friends' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_friends' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_friends' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_friends' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_mailqueue' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_mailqueue' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_mailqueue' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_mailqueue' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_memberfields' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_memberfields' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_memberfields' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_memberfields' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_memberfields' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_memberfields' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_members' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_members' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_members' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_members' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_members' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_members' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_members' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_members' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_members' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_members' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_members' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_members' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_members' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_members' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_members' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_members' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_members' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_members' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_members' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_members' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_members' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_mergemembers' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_mergemembers' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_mergemembers' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_mergemembers' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_newpm' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_newpm' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_newpm' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_newpm' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_newpm' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_notelist' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_notelist' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_notelist' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_notelist' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_notelist' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_pm_indexes' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_pm_indexes' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_indexes' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_indexes' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_indexes' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_pm_lists' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_pm_lists' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_lists' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_lists' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_lists' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_lists' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_lists' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_pm_members' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_pm_members' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_members' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_members' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_members' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_pm_messages_0' (errno: 13)
Query OK, 0 rows affected (0.01 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_0' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_0' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_0' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_0' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_pm_messages_1' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_1' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_1' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_1' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_1' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_pm_messages_2' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_2' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_2' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_2' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_2' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_pm_messages_3' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_3' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_3' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_3' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_3' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_pm_messages_4' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_4' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_4' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_4' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_4' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_pm_messages_5' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_5' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_5' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_5' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_5' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_pm_messages_6' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_6' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_6' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_6' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_6' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_pm_messages_7' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_7' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_7' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_7' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_7' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_pm_messages_8' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_8' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_8' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_8' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_8' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_pm_messages_9' (errno: 13)
Query OK, 0 rows affected (0.01 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_9' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_9' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_9' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_pm_messages_9' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_protectedmembers' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_protectedmembers' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_protectedmembers' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_protectedmembers' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_protectedmembers' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_settings' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_settings' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_settings' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_settings' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_settings' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_sqlcache' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_sqlcache' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_sqlcache' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_sqlcache' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_tags' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_tags' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_tags' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_tags' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_tags' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1005 (HY000): Can't create table 'uc_vars' (errno: 13)
Query OK, 0 rows affected (0.00 sec)

ERROR 1146 (42S02): Table 'ucenter.uc_vars' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_vars' doesn't exist
ERROR 1146 (42S02): Table 'ucenter.uc_vars' doesn't exist
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

显示的不只这些。也不只 'ucenter.uc_admins' 这一个表,还有其他的表。
我见状不行。便停止了源数据库服务器上的Mysql服务。然后把数据库文件夹复制过来了,然后启动新的数据库服务。得到的结果是,丢失了5万多个member里面的用户数据。
我怀疑过数据库有问题,但是检查了以下都正常。而且我是一只运行着的UC数据库。
请大家帮忙分析一下。
补充以下。源数据库运行在windows主机上面。新的数据库服务器是Linux

baxter 发表于 2013-9-15 13:30:33 | 显示全部楼层
转移前原数据已出问题了吧?
回复

使用道具 举报

 楼主| 恒少少 发表于 2013-9-15 16:14:54 | 显示全部楼层
baxter 发表于 2013-9-15 13:30
转移前原数据已出问题了吧?

不能吧。用的好好的啊
回复

使用道具 举报

xiaoyuwxz 发表于 2013-9-18 13:22:26 | 显示全部楼层
直接拷贝数据表,
不要在备份时还包括创建用户和库名,
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

手机版|小黑屋|Discuz! 官方站 ( 皖ICP备16010102号 )star

GMT+8, 2024-12-25 15:50 , Processed in 0.023433 second(s), 4 queries , Gzip On, Redis On.

Powered by Discuz! X3.4

Copyright © 2001-2023, Tencent Cloud.

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