长沙建网站培训机构廊坊北京网站建设

CentOS7仅安装部署MySQL80客户端

一、前言

1.场景

• 仅安装部署MySQL80客户端，用于备份数据库时使用 mysqldump 工具

2.环境

• Linux 发行版：CentOS-7-x86_64-DVD-1804.iso
• MySQL 版本：mysql-community-client-8.0.34-1.el7.x86_64.rpm

MySQL Product Archives：https://downloads.mysql.com/archives/community/

CentOS7安装部署MySQL80：https://blog.csdn.net/u011424614/article/details/132418916

CentOS7部署MySQL80集群：https://blog.csdn.net/u011424614/article/details/133222091

CentOS基础操作命令：https://blog.csdn.net/u011424614/article/details/94555916

[ContOS] MySQL安装部署：https://blog.csdn.net/u011424614/article/details/94555816

CentOS7安装部署双版本MySQL：https://blog.csdn.net/u011424614/article/details/140254002

二、正文

1.安装MySQL客户端

# 查看系统是否已安装 mysql 历史版本
rpm -qa|grep mysql
rpm -qa|grep mariadb# 如存在 mysql 历史版本可用以下命令，依次进行卸载安装包
yum remove -y mariadb-libs-5.5.68# 官网下载安装包
wget https://cdn.mysql.com/archives/mysql-8.0/mysql-community-common-8.0.34-1.el7.x86_64.rpm
wget https://cdn.mysql.com/archives/mysql-8.0/mysql-community-client-plugins-8.0.34-1.el7.x86_64.rpm
wget https://cdn.mysql.com/archives/mysql-8.0/mysql-community-libs-8.0.34-1.el7.x86_64.rpm
wget https://cdn.mysql.com/archives/mysql-8.0/mysql-community-client-8.0.34-1.el7.x86_64.rpm# 依次安装
rpm -ivh mysql-community-common-8.0.34-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.34-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.34-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.34-1.el7.x86_64.rpm# 验证mysql客户端是否安装成功
mysql --version
which mysqldump

2. 数据库备份脚本

• 一次备份多个数据库

cat > /opt/backup/mysql_backup.sh <<EOF
#!/bin/bash# 定义变量
REMOTE_HOST="192.168.28.159"
REMOTE_USER="root"
REMOTE_PASS="Root@123456"
REMOTE_PORT="3306"
REMOTE_DATABASES=("dev001" "dev002" "dev003")
BACKUP_DIR="/opt/backup/database"
TIMESTAMP=$(date +%Y%m%d)# 创建备份根目录
mkdir -p ${BACKUP_DIR}/${TIMESTAMP}# 备份数据库
for DB in "${REMOTE_DATABASES[@]}"
do# 创建数据库的备份目录DB_BACKUP_DIR=${BACKUP_DIR}/${TIMESTAMP}/${DB}mkdir -p ${DB_BACKUP_DIR}echo "正在备份数据库：${DB}"mysqldump -h ${REMOTE_HOST} -P ${REMOTE_PORT} -u ${REMOTE_USER} -p${REMOTE_PASS} ${DB} > ${DB_BACKUP_DIR}/${DB}_${TIMESTAMP}.sql
doneecho "备份完成，数据库已保存至： ${BACKUP_DIR}/${TIMESTAMP}"
EOF

• 设置权限

chmod 755 /opt/backup/mysql_backup.sh