2.6.1恢复数据出现问题?

2016-07-07 15:46 来源:www.chinab4c.com 作者:ecshop专家

标准备份时候,出现问题

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SHOW CREATE TABLE `ecs_admin_user` ) [2] => Array ( [error] => Table '4adown.ecs_admin_user' doesn't exist ) [3] => Array ( [errno] => 1146 ) )

全部备份 则不出现问题!


恢复数据时候,出现 一段代码

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => CREATE TABLE `ecs_account_log` ( `log_id` mediumint(8) unsigned NOT NULL auto_increment, `user_id` mediumint(8) unsigned NOT NULL default '0', `user_money` decimal(10,2) NOT NULL default '0.00', `frozen_money` decimal(10,2) NOT NULL default '0.00', `rank_points` mediumint(9) NOT NULL default '0', `pay_points` mediumint(9) NOT NULL default '0', `change_time` int(10) unsigned NOT NULL default '0', `change_desc` varchar(255) NOT NULL default '', `change_type` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`log_id`), KEY `user_id` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk DEFAULT CHARSET=utf8 ) [2] => Array ( [error] => Conflicting declarations: 'CHARACTER SET gbk' and 'CHARACTER SET utf8' ) [3] => Array ( [errno] => 1302 ) )

求救!

回答:
解决方案 可以恢复http://bbs.ecshop.com/viewthread ... hlight=%B1%B8%B7%DD

但标准备份时候,还是出现问题

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SHOW CREATE TABLE `ecs_admin_user` ) [2] => Array ( [error] => Table '4adown.ecs_admin_user' doesn't exist ) [3] => Array ( [errno] => 1146 ) )

你的数据库缺表吧,看看这个表ecs_admin_user还有吗?

在哪里找啊?

看看数据库里是否有这个表,再看看备份的数据里是否有这个表