January 2019
Intermediate to advanced
798 pages
20h 33m
English
Restoring such a backup is simple as well. We pass the saved statements to the MySQL client, uncompressing them first, if necessary:
$ bzcat zabbix_database_backup.db.bz2 | mysql zabbix -u zabbix -p
Of course, backups are useful only if it's possible to restore them. As required by any backup policy, the ability to restore from backups should be tested. This includes restoring the database dump, but it's also suggested to compare the schema of the restored database and the default schema, as well as running a copy of the Zabbix server on a test system. Make sure to disallow ...
Read now
Unlock full access