MYSQL 备份注意事项和报错合集

MYSQL 备份注意事项和报错合集

1. 主要mysql备份软件兼容的版本信息；

2. 注意备份用户的权限；

3. 注意备份目录是否创建完成；

4. 主要备份使用到的例如压缩命令的是否存在；

5.远程流备份时主要目标端的备份软件是否安装。

 

常见备份错误和处理方式：

1. 备份中用到的软件pbzip2未安装：

021-01-11 10:51:22 0x7f05234dc800 InnoDB: Using Linux native AIO
xtrabackup: using O_DIRECT
Number of pools: 1
210111 10:51:22 Connecting to MySQL server host: localhost, user: root, password: set, port: 3306, socket: /tmp/mysql3306.sock
xtrabackup: Redo Log Archiving is not set up.
Starting to parse redo log at lsn = 4952923330161
Recovery parsing buffer extended to 4194304.
Recovery parsing buffer extended to 8388608.
Recovery parsing buffer extended to 16777216.
Recovery parsing buffer extended to 33554432.
Recovery parsing buffer extended to 67108864.
xtrabackup: Error writing file '<unopen fd>' (OS errno 32 - Broken pipe)
xb_stream_write_data() failed.
xtrabackup: Error: write to logfile failed

处理方式：

 rpm -ivh pbzip2-1.1.13-1.el8.x86_64.rpm