主页 / 问题 / 688159
Accepted
Samvel
Asked:2020-07-06 23:06:43 +0000 UTC2020-07-06 23:06:43 +0000 UTC

MySQL二进制日志

  • 772

我无法启用二进制日志记录。我在互联网上发现可以通过取消注释log_bin = /var/log/mysql/mysql-bin.log配置文件中的行来启用二进制日志/etc/mysql/my.cnf。但是没有这样的项目。

这是该配置文件中的内容：

# The MariaDB configuration file
#
# The MariaDB/MySQL tools read configuration files in the following order:
# 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults,
# 2. "/etc/mysql/conf.d/*.cnf" to set global options.
# 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options.
# 4. "~/.my.cnf" to set user-specific options.
#
# If the same option is defined multiple times, the last one will apply.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.

#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

# Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/

我进入文件夹/etc/mysql/conf.d/和/etc/mysql/mariadb.conf.d/文件mysqld.cnf，50-server.cnf找到并取消注释这些行，但仍然没有保留日志。

操作系统：Ubuntu 16.04

mysql

1 个回答

  1. Best Answer

    试试看：

    server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size = 100M
#binlog_do_db = include_database_name
#binlog_ignore_db = include_database_name

    接下来，重新启动 DBMS：

    /etc/init.d/mysql restart

    我们确保二进制日志已经创建并且大小开始增长：

    ls -al /var/log/mysql
total 16K
drwxr-s--- 2 mysql adm 4.0K 2010-05-17 04:40 .
drwxr-xr-x 14 root root 4.0K 2010-05-16 06:25 ..
-rw-rw---- 1 mysql adm 471 2010-05-17 04:41 mysql-bin.000001
-rw-rw---- 1 mysql adm 32 2010-05-17 04:40 mysql-bin.index

    取消注释这一行log-bin=mysql-bin

    • 3

相关问题