Shulou(Shulou.com)06/02 Report--

In zabbix monitoring, zabbix servers are sometimes migrated as needed, and zabbix migration is very simple because all the operations on the front end of zabbix are stored in the zabbix database. So zabbix migration only needs to export and import the corresponding tables in the zabbix library.

Zabbix migration can be performed separately for whether to migrate historical data. If historical data is not lost, then the entire zabbix library needs to be migrated. If historical data is not required, only configuration information can be migrated. After all, historical data takes up a lot of space.

1. Export zabbix database

[root@zhu2] # mysqldump-uroot-p123456-- opt zabbix > zabbix.sql

two。 Transfer sql files to the new server (the basic environment on the new server should be set up)

[root@zhu2 ~] # scp zabbix.sql root@192.168.70.133:/tmp

3. Import the sql file on the new server

[root@zhu1] # mysql-uroot-p123456 zabbix

< zabbix.sql #zabbix库可以是一个新建的库，也可以是已经存在的库，因为sql文件再导入时，会先看表是否存在，假如表存在会先删除再导入 4.修改网页文件 [root@zhu1 ~]# vim /var/www/html/conf/zabbix.conf.php ~ 5.前端访问， #此时需要使用的便是老的zabbix的用户密码，为了防止迁移不出意外，新的服务器上搭建的环境，以及zabbix server的配置文件应尽量和老的配置文件保持一致 zabbix3.2升级3.4报错Database error zabbix3.2版本升级到zabbix3.4版本后打开页面报错，报错内容如下 Database error The frontend does not match Zabbix database. Current database version (mandatory/optional): 3020000/3020000. Required mandatory version: 3040000. Contact your system administrator. 解决办法： 进入数据库 mysql>

Show databases;mysql > use zabbix;mysql > update dbversion set mandatory=3040000;mysql > flush privileges

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.