各位朋友请教一个问题,我在网站迁移,恢复数据库时出现如下问题,是什么原因,该如何解决?CREATE command denied to user 'root'@'localhost' for table 'phome_ecms_article'
CREATE TABLE `***_ecms_article` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `classid` smallint(5) unsigned NOT NULL DEFAULT '0', `ttid` smallint(5) unsigned NOT NULL DEFAULT '0', `onclick` int(10) unsigned NOT NULL DEFAULT '0', `plnum` mediumint(8) unsigned NOT NULL DEFAULT '0', `totaldown` mediumint(8) unsigned NOT NULL DEFAULT '0', `newspath` char(20) NOT NULL DEFAULT '', `filename` char(36) NOT NULL DEFAULT '', `userid` mediumint(8) unsigned NOT NULL DEFAULT '0', `username` char(20) NOT NULL DEFAULT '', `firsttitle` tinyint(1) NOT NULL DEFAULT '0', `isgood` tinyint(1) NOT NULL DEFAULT '0', `ispic` tinyint(1) NOT NULL DEFAULT '0', `istop` tinyint(1) NOT NULL DEFAULT '0', `isqf` tinyint(1) NOT NULL DEFAULT '0', `ismember` tinyint(1) NOT NULL DEFAULT '0', `isurl` tinyint(1) NOT NULL DEFAULT '0', `truetime` int(10) unsigned NOT NULL DEFAULT '0', `lastdotime` int(10) unsigned NOT NULL DEFAULT '0', `havehtml` tinyint(1) NOT NULL DEFAULT '0', `groupid` smallint(5) unsigned NOT NULL DEFAULT '0', `userfen` smallint(5) unsigned NOT NULL DEFAULT '0', `titlefont` char(14) NOT NULL DEFAULT '', `titleurl` char(200) NOT NULL DEFAULT '', `stb` tinyint(3) unsigned NOT NULL DEFAULT '1', `fstb` tinyint(3) unsigned NOT NULL DEFAULT '1', `restb` tinyint(3) unsigned NOT NULL DEFAULT '1', `keyboard` char(80) NOT NULL DEFAULT '', `title` char(100) NOT NULL DEFAULT '', `newstime` int(10) unsigned NOT NULL DEFAULT '0', `titlepic` char(120) NOT NULL DEFAULT '', `ftitle` char(120) NOT NULL DEFAULT '', `smalltext` char(255) NOT NULL DEFAULT '', `writer` char(30) NOT NULL DEFAULT '', `befrom` char(60) NOT NULL DEFAULT '', `newstext` char(50) NOT NULL DEFAULT '', `diggtop` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `classid` (`classid`), KEY `newstime` (`newstime`), KEY `ttid` (`ttid`), KEY `firsttitle` (`firsttitle`), KEY `isgood` (`isgood`), KEY `ispic` (`ispic`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
我后来发现是用帝国7.2的原因,我换成7.0就可以恢复数据库了。但在恢复栏目时又出现下面的问题:Unknown column 'ipport' in 'field list'
insert into ***_enewsdolog(username,logip,logtime,enews,doing,pubid,ipport) values('chadmin','127.0.0.1','2015-05-26 18:24:15','ReData','dbname=empirecms&path=chketang_20150526075618','0','2041');
第二个问题请麻烦再帮我看看是什么原因,谢谢
追答ipport 你看看数据库有没有这个字段,你是还原数据库吗?