Shulou(Shulou.com)06/01 Report--

The following error occurred when importing data using MySQL workbench today:

Find the information and solve the problem:

Reference link: http://blog.csdn.net/cug_jiang126com/article/details/49945643 http://blog.csdn.net/topasstem8/article/details/8216740/

Question 1 Restoring 16 Documents 09 Restoring D:\ Files\ Documents\ dumps\ test. 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 master问题2：16: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 errors解决办法：mysql>

Set global log_bin_trust_function_creators=TRUE;Query OK, 0 rows affected (0.00 sec)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.