Once you have your Zabbix server up and running, it's important to back up your Zabbix configuration in case you should run into problems. In this topic, we will cover what we need to backup and how to do it. While it's not really a recipe on how to backup as each Zabbix set up is different and not everybody uses MySQL or PostgreSQL, we will show you how to run your backups.
In the crontab of your server, add the following line:
1 0 * * * mysqldump -u <user> -p<password> <zabbixdb> > /backup/zabbix_db_backup
This recipe showed a basic backup of the MySQL database of our Zabbix server. When we backup Zabbix, it depends on what database we have used to do our backup. To avoid locking, it is possible to make use of tools such as Percona XtraBackup. When you work with PostgreSQL, you could make use of the pg_dump utility.
The database is the...