How to rollback from backup?

[fab]

Hi there,

a bug in zabbix 1.0 php frontend trashed my database and since then suckerd crashes randomly every few days. So I wonder what I had to do to successfully backup and restore my data.

Here is what I did:

I already expected zabbix to fail so I made a full mysql dump of the database before I tried to give zabbix circular dependecies (which I would be glad to have because of the backbone (small ISP) I would like to monitor). After telling zabbix that trigger b depends on a and c and that trigger a depends on b it just gone mad and filled the dependencies of all triggers (and for all hosts) with every trigger that exists randomly and was captured within a infinite loop.

After that I dropped the zabbix database and refilled it with the data from the dump. Everything was there and seemed to be alright. After restarting suckerd even the timestamps had been corrected and up to date. But then occassionaly after a few days suckerd reported misformed SQL Queries and died. I deactivated the item and restarted suckerd but with no helpfull effect. Suckerd just reported a misformed SQL query for the next item. Actually suckerd runs perfectly from the restart to day X and then suddenly thinks that something is being wrong. And it did its job perfectly before the circular dependency.

So what went wrong and how do I make a useful backup and restore it?

Regards,
Frank.

[Rudolf]

The question about backing up the Zabbix MySQL database is asked several times in the forum. (Use the search function for the word backup).

I monitor less then 20 servers with Zabbix. I just have a mysqldump in cron.daily. And I exclude the trends and history tables. But I hope I will never have to make a restore. Because I use always the latest alpha version. And we know that the mysql table format changes with almost every new release.