您好,登錄后才能下訂單哦!
查找資料后解決:
參考鏈接:http://blog.csdn.net/cug_jiang126com/article/details/49945643 http://blog.csdn.net/topasstem8/article/details/8216740/
16:09:51 Restoring D:\Files\Documents\dumps\測試.sql
Running: 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 1
16:09:52 Import of D:\Files\Documents\dumps\測試xwjr_server.sql has finished with 1 errors
解決辦法:
reset master
16:09:23 Restoring D:\Files\Documents\dumps\測試.sql
Running: 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 1
16: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)
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場,如果涉及侵權(quán)請(qǐng)聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。