记录一次mysql5.7.21_binlog日志恢复

从 mysql 官网下载并上传 mysql安装包

mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz

tar -zvxf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz

mv mysql-5.7.17-linux-glibc2.5-x86_64 /usr/lcoal/mysql

groupadd mysql

useradd -r -g mysql mysql

yum search libaio

cd /usr/local/mysql/

cp ./support-files/my-default.cnf /etc/my.cnf（提示是否覆盖，输入“ y ”同意）

vim /etc/my.cnf

[mysql] 

# 设置mysql客户端默认字符集 

default-character-set=utf8 

socket=/var/lib/mysql/mysql.sock 

[mysqld] 

#skip-name-resolve 

#设置3306端口 

port = 3306 

socket=/var/lib/mysql/mysql.sock 

# 设置mysql的安装目录 

basedir=/usr/local/mysql 

# 设置mysql数据库的数据的存放目录 

datadir=/usr/local/mysql/data 

# 允许最大连接数 

max_connections=200 

# 服务端使用的字符集默认为8比特编码的latin1字符集 

character-set-server=utf8 

# 创建新表时将使用的默认存储引擎 

default-storage-engine=INNODB 

#lower_case_table_name=1 

max_allowed_packet=16M 

mkdir ./data

chown -R mysql:mysql ./

./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/

cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld

chmod +x /etc/rc.d/init.d/mysqld

chkconfig --add mysqld

service mysqld start

vim /etc/profile

PATH = $PATH:/usr/local/mysql/bin

export PATH

source /etc/profile

use msyql

grant all privileges on *.* to root@"%" identified by "password" with grant option;

flush privileges;

my.cnf

log-bin=/usr/local/mysql/mysql-bin  #开启logbin日志

利用binlog恢复

mysqlbinlog --start-position="298" --stop-position="410" mysql-bin.000001 | mysql -u root -p test  test是数据库名称

Xiaoqian03051993@

运维QQ交流群：171586999