速卖通网站怎么做推广,网站数据库 mysql,有专业做网站的,深圳龙华房价2022最新房价文章目录 CentOS7仅安装部署MySQL80客户端一、前言1.场景2.环境 二、正文1.安装MySQL客户端2. 数据库备份脚本 CentOS7仅安装部署MySQL80客户端
一、前言
1.场景
仅安装部署MySQL80客户端#xff0c;用于备份数据库时使用 mysqldump 工具
2.环境
Linux 发行版#xff1a… 文章目录 CentOS7仅安装部署MySQL80客户端一、前言1.场景2.环境 二、正文1.安装MySQL客户端2. 数据库备份脚本 CentOS7仅安装部署MySQL80客户端
一、前言
1.场景
仅安装部署MySQL80客户端用于备份数据库时使用 mysqldump 工具
2.环境
Linux 发行版CentOS-7-x86_64-DVD-1804.isoMySQL 版本mysql-community-client-8.0.34-1.el7.x86_64.rpm MySQL Product Archiveshttps://downloads.mysql.com/archives/community/ CentOS7安装部署MySQL80https://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安装部署双版本MySQLhttps://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 mysqldump2. 数据库备份脚本
一次备份多个数据库
cat /opt/backup/mysql_backup.sh EOF
#!/bin/bash# 定义变量
REMOTE_HOST192.168.28.159
REMOTE_USERroot
REMOTE_PASSRoot123456
REMOTE_PORT3306
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
