mysqldump恢复备份出现的难题

2024-07-24 12:34:59

字体：大中小

来源：转载

供稿：网友

　　今天使用MySQL workbench导入数据的时候出现了以下报错：

　　问题1：
　　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
　　问题2：
　　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)

（编辑：武林网）

上一篇：MySQL8.0新特征--Group by

下一篇：mysql 主从复制原则