ituser - 小小IT人遨游大大IT界

Centos7迁移zabbix数据库

2018-07-29 16:37:12 105次浏览


时间久了数据库占用磁盘空间,转移到新挂载磁盘 省略挂载磁盘 备份: [root@ituser data]# cp /etc/my.cnf /etc/my.cnf.bk 修改mysql配置文件: my.cnf: datadir=/var/lib/mysql datadir=/home/data/mysql

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

[root@ituser data]# systemctl stop zabbix-agent [root@ituser data]# systemctl stop zabbix-server [root@ituser data]# systemctl stop mysqld [root@ituser data]# systemctl stop nginx [root@ituser ~]# systemctl stop php-fpm

这里选择的是复制: [root@ituser data]# cp -a /var/lib/mysql /home/data 很关键的一步: [root@ituser data]# ln -s /home/data/mysql/mysql.sock /var/lib/mysql [root@ituser data]# systemctl start mysqld [root@ituser data]# systemctl start nginx [root@ituser data]# systemctl start php-fpm [root@ituser data]# systemctl start zabbix-server [root@ituser data]# systemctl start zabbix-agent 谢谢关注!

说明

所有内容来及个人经验和互联网摘取,如有雷同纯属巧合,如有冒犯,欢迎留言,分享即快乐,感谢互联网中每一位懂得分享的ituser!QQ群:127331971(备注:ituser.cn)