variable 提示无效sql_mysql恢复数据数据出现Variable sql_mode cant 解决方法

用mysqldump导出的数据文件，再用source导进去的时候常常有一些报错 ariable sql_mode cant be set to the value of NULL，百度了好几回，终于找到是mysql导出的注释语句问题，导出的文件常常 如下：

01./*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

02./*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

03./*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

04./*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

05./*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

06./*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

07./*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

解决办法

解决方法：删除注释语句后再执行批量SQL语句操作

利用二进制日志恢复报错？Variable 'sql_mode' can't be set to the value of '1344274432'

Server version 5.0.18-log

Protocol version 10

Connection localhost via TCP/IP

操作系统: windowsXp

mysql为InnoDB存储引擎

数据库为utf

win.ini中配置

[mysql]

default-character-set=utf8

[mysqld]

basedir="c:/MySQL5/"

datadir="c:/MySQL5/Data/"

log-bin="d:/log/log"

binlog-do-db=test

innodb_data_home_dir =

innodb_data_file_path=e:/MySQL Datafiles/ibdata1:10M;e:/MySQL Datafiles/ibdata2:1M:autoextend

innodb_log_group_home_dir="d:/log/binlog/"

default-character-set=utf8

default-storage-engine=INNODB

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

...........