qq_38253703的博客

一、备份数据库mysqldump -h 127.0.0.1 -uusername -ppassword --single-transaction databasename|gzip > /www/backup/database/databasename_`date +%Y%m%d`.dump.gz将数据备份到本地的话 -h可以不用写，将数据备份到远程，将127.0.0.1换成远程IP地址即可二、还原数据库mysql -uusername -ppassword databasename &lt

操作环境操作系统：centos7.6数据库：mysql 5.71. 配置my.cnfcentos命令:vi /etc/my.cnf 打开编缉在[mysqld]下面添加以下代码数据库A：server-id=1log-bin=master-binlog-slave-updates=trueauto_increment_increment=2auto_increment_offs...

在MySQL官网中查看YUM源rpm安装包：http://dev.mysql.com/downloads/repo/yum/下载mysql安装源： wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm安装mysql源：yum localinstall mysql80-community-relea...

一、主服务器(ip:192.168.1.112)修改mysql.cnf文件：vi /etc/my.cnf在[mysqld]下添加:log-bin=mysql-bin #开启二进制日志server-id=1 #设置server-id重启mysql,并登录mysql创建授权用户：grant replication slave on *.* to 'slave'@'%' iden...

转发：https://www.cnblogs.com/biglittleant/p/7059569.html

转发：https://blog.youkuaiyun.com/dream_broken/article/details/77675569