易截截图软件、单文件、免安装、纯绿色、仅160KB

用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的连接超时时间怎么设置 - VC/MFC / 数据库

我是用mysql自带的C API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("数据库连接失败") ......

MySql问题

MySql中插入当前时间的该怎么写啊?
now()

SQL code:

sql里是:
getdate()

引用
now()


学习

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......

mysql 简单问题

假如数据库中有个test表,表中有id,Name,num,记录时间
id为自增长主键,name是名字,num表示其数量

1  nike  100        系统时间
2  nike  300  &n ......

mysql 导致死机

环境: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 ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号