How to change Zabbix Database

[target]

Hello All,

I am trying to change the database to Zabbix 6.2. Basically I have copied an old mysql database from another Zabbix and need to load it on a new Zabbix server. Is it possible?


Best Regards,

[Markku]

Yes, see for example https://majornetwork.net/2022/01/mov...bbix-database/

The steps in brief:
- Dump the database on the old server: mysqldump --single-transaction zabbix | gzip > /mnt/zbx-dump.sql.gz
- Copy the file to the new server
- Create the new empty database on the new server and create the zabbix database user (see Zabbix installation documentation for details if needed)
- Load the database: zcat zbx-dump.sql.gz | mysql -u zabbix -p zabbix

When starting the new Zabbix server with the new database it will automatically update the database to the new schema, see zabbix_server.log for any errors.

(Disclaimer: the commands above were tested with MariaDB 10.1.x and 10.5.x, in MySQL the command defaults may be different, I don't know.)

Markku

[Markku]

Yes, see for example https://majornetwork.net/2022/01/mov...bbix-database/

The steps in brief:
- Dump the database on the old server: mysqldump --single-transaction zabbix | gzip > /mnt/zbx-dump.sql.gz
- Copy the file to the new server
- Create the new empty database on the new server and create the zabbix database user (see Zabbix installation documentation for details if needed)
- Load the database: zcat zbx-dump.sql.gz | mysql -u zabbix -p zabbix

When starting the new Zabbix server with the new database it will automatically update the database to the new schema, see zabbix_server.log for any errors.

(Disclaimer: the commands above were tested with MariaDB 10.1.x and 10.5.x, in MySQL the command defaults may be different, I don't know.)

Markku