- 论坛徽章:
- 0
|
以下是我 数据库还原的代码,但总还原不成功,但在phpmyadmin里面把back.txt导入就成功。
所以问高手一下下:
这个程序是不是哪里出了问题?
谢谢指点。
@set_time_limit(0);
$filename='back.txt';
$lines=file($filename);
foreach($lines as $line){
$mysh.=$line;
}
$mysqlrefresh=explode(';',$mysh);
foreach($mysqlrefresh as $line1){
$rf=$db->q($line1);
mysql_free_result($rf);
}
if($rf==true){
echo '<script>alert("还原成功");history.go(-1);</script>';
}else{
echo '<script>alert("还原失败");history.go(-1);</script>';
}
报错如下:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE IF EXISTS my_admin' at line 1
back.sql里面代码如下:
DROP TABLE IF EXISTS my_admin;
CREATE TABLE `my_admin` (
`admin_id` int(10) NOT NULL auto_increment,
`admin_name`
varchar(100) NOT NULL,
`admin_right` int(5) NOT NULL,
`admin_passwd` varchar(100) NOT NULL,
`admin_email` varchar(100)
NOT NULL,
`admin_qq` int(20) default NULL,
`admin_rname` varchar(100) NOT NULL,
`admin_lastime` datetime default NULL,
PRIMARY KEY (`admin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|