用mysql administrator导入PHPmyadmin导出的SQL
用PHPMYADMIN导出了SQL文件现在想用Mysql administrator导入可是出错了
The dump file was not created by MySQL Administrator and could contain unsupported syntax.
Hence we cannot restore its content.
You can override this behavior by enabling "Ignore errors" on the General page.
估计格式上有所差别,看一下是哪句不对?
The dump file was not created by MySQL Administrator and could contain unsupported syntax.
Hence we cannot restore its content.
You can override this behavior by enabling "Ignore errors" on the General page.
错误表述的很明显 语法不一致 含有mysql不支持的语法
如果强制导入的加上
--force
相关问答:
我是用mysql自带的C API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("数据库连接失败") ......
MySql中插入当前时间的该怎么写啊?
now()
SQL code:
sql里是:
getdate()
引用
now()
学习
SQL code:
select now();
SQL code:
TODAY()
?
SQL code:
select now();
/* ......
假如数据库中有个test表,表中有id,Name,num,记录时间
id为自增长主键,name是名字,num表示其数量
1 nike 100 系统时间
2 nike 300 &n ......
环境:win2003 apache2 resin3 php5 mysql5
mysql错误里出现这个,服务器直接死到那里。
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_log ......