mysqldump: Error: Binlogging on server not active报错解决办法
来源:互联网 发布:在mac上用win to go 编辑:程序博客网 时间:2024/06/01 08:22
今天利用命令mysqldump备份mysql数据库时增加--master-data=1参数时,备份报错:
================================================================================
-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)
--
-- Host: localhost Database: mysqllocal_%date:0,4%_%date:5,2%_%date:8,2%.sql
-- ------------------------------------------------------
-- Server version 5.7.17-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
mysqldump: Error: Binlogging on server not active
=================================================================================
解决办法:windows下修改my.ini文件(linux下修改my.cnf文件)查找:log-bin参数 添加如下行:
log-bin=mysql-bin
保存文件,退出。重启mysql服务,继续在cmd或者shell下备份操作即可!
- mysqldump: Error: Binlogging on server not active报错解决办法
- mysqldump备份报Binlogging on server not active的解决
- MySQL 使用mysqldump命令出现错误Binlogging on server not active解决方法
- zabbix客户端日志报错no active checks on server [192.168.3.108:10051]: host [192.168.3.108] not found
- Navicat连接远程mysql数据库error报错2003 can't connect to mysql server on 10038解决办法
- xcode 报错xcrun: error: active developer path ("/Applications/Xcode.app/Contents/Developer/") does not
- LaTeX报错解决办法 Error: File 'amsmath.sty' not found
- Could not publish to the server.报错解决办法
- tftp Error on server : Access violation解决办法
- mysqldump: Got error: 2003: Can't connect to MySQL server on '127.0.0.1' (10061)
- oracle启动报错ORA-00845: MEMORY_TARGET not supported on this system解决办法
- oracle报错ORA-00845: MEMORY_TARGET not supported on this system的解决办法
- spark on yarn报错ERROR GPLNativeCodeLoader: Could not load native gpl library
- mysqldump 备份报错
- mysqldump报错
- mysqldump 备份报错
- mysqldump报错
- 安装lua提示xcrun: Error: could not stat active Xcode path的解决办法
- JAVA集合框架——规则集
- git reset 之 soft mixed hard选项的区别
- 用两个栈实现队列
- Android adb命令使用总结
- mybatis+spring的TODO小项目记录(八)整合spring和mybatis
- mysqldump: Error: Binlogging on server not active报错解决办法
- 杭电 oj 1016 Prime Ring Problem
- Maven学习笔记
- 每天喝6杯清水,就能轻松瘦身!
- [RK3288][Android6.0] WiFi在Setting中的开启过程小结
- Java实现单链表反转
- 在IDEA上创建web项目以及tomcat server的配置
- 机器学习算法集锦:从贝叶斯到深度学习及各自优缺点
- Hat’s Words (字典树 + 智能指针shared_ptr)