Backup /Migration

[roycruse]

Can someone confirm to me if the entire config and history of a working zabbix server is stored in the database plus the zabbix-server.conf and zabbix-agentd.conf files

So if I wanted to migrate my complete setup and all history data to a new server I would simply need these 3 things on top of the zabbix install.

Many thanks...

[nicolasfo]

Hello,
You can have a look to this page
You have a backup script and you'll have to select "all data".

Nicolas

[roycruse]

i dont suppose there is an equivalent script for 3.2.x installations ?

a backup / restore option within zabbix itself would be awesome

[nicolasfo]

Personally, I had to adapt the script because some tables have been deleted and others have been created between the two versions.
To do this, I used phpmyadmin to list all tables and added or deleted tables one by one.
It's crappy, but it's the easiest way I found to have my script up-to-date quickly.
So if you can't wait you'll have to do like this but if you can wait, it's possible an updated script will be posted.

[louis-m]

Personally, I had to adapt the script because some tables have been deleted and others have been created between the two versions.
To do this, I used phpmyadmin to list all tables and added or deleted tables one by one.
It's crappy, but it's the easiest way I found to have my script up-to-date quickly.
So if you can't wait you'll have to do like this but if you can wait, it's possible an updated script will be posted.

I'd certainly vote for this. It would be such a simple thing to do for the Zabbix team and every time they alter the tables/schema etc, it's the obvious place to make the change.
It's a bit of a pain having to continuously check the table structure and alter the script with upgrades and your config on zabbix can get very complex so config backups are a must.

[zabbixfk]

Backup /Migration

Yes. All the configs and history are stored in db plus config files such as zabbix_server.conf and zabbix_agentd.conf - if you have client / server specific configs ( for tuning for example).

In case of new server setup :
I would take entire database backup and source at new place , compile zabbix ( same version as on old machine) , replace config files , bring up zabbix.

In case of upgrade:
Same as above, only difference is - compiling newer zabbix version. Copying newer zabbix configuration files. Then doing file diff to copy tuning & serve/client specific configurations. Starting new zabbix server, it would take care of upgrading database.

In case of blind backup - for future restore :
Take database dumps, config files backup on regular basis and keep it.

All three cases, don't forget to backup, your specific scripts under externalscripts or any other custom locations.

Hope this helps.

Thanks