12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
ADADADADAD
mysql数据库 时间：2024-12-24 19:11:52
作者：文/会员上传
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
今天使用MySQL workbench导入数据的时候出现了以下报错：查找资料后解决：参考链接：http://blog.csdn.net/cug_jiang126com/article/details/49945643http://blog.csdn.net/topas
以下为本文的正文内容，内容仅供参考！本站为公益性网站，复制本文以及下载DOC文档全部免费。
查找资料后解决：
参考链接：http://blog.csdn.net/cug_jiang126com/article/details/49945643http://blog.csdn.net/topasstem8/article/details/8216740/
16:09:51 Restoring D:\Files\Documents\dumps\测试.sqlRunning: mysql.exe --defaults-file="c:\users\xwjr\appdata\local\temp\tmp1acjjn.cnf"--protocol=tcp --host=127.0.0.1 --user=root --port=3306 --default-character-set=utf8 --comments --database=xwjr_server< "D:\\Files\\Documents\\dumps\\测试.sql"ERROR 1840 (HY000) at line 26: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.Operation failed with exitcode 116:09:52 Import of D:\Files\Documents\dumps\测试xwjr_server.sql has finished with 1 errors解决办法：
reset master16:09:23 Restoring D:\Files\Documents\dumps\测试.sqlRunning: mysql.exe --defaults-file="c:\users\xwjr\appdata\local\temp\tmpenrr12.cnf"--protocol=tcp --host=127.0.0.1 --user=root --port=3306 --default-character-set=utf8 --comments --database=xwjr_server< "D:\\Files\\Documents\\dumps\\测试.sql"ERROR 1418 (HY000) at line 2395: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)Operation failed with exitcode 116:09:40 Import of D:\Files\Documents\dumps\测试.sql has finished with 1 errorsmysql> set global log_bin_trust_function_creators=TRUE;Query OK, 0 rows affected (0.00 sec)11-20
11-19
11-20
11-20
11-20
11-19
11-20
11-20
11-19
11-20
11-19
11-19
11-19
11-19
11-19
11-19