I don't really trust the structure of my database anymore and would like to use the same trick I did a while ago.
I ran several of the sql files in the pathes folder in the trunk and many of them failed.
The webif also showed several routers (all the same make) as suddenly unavailable.
I still don't know if it's the DB-patches that did this or the trunk upgrade itself.
You suggested a procedure in this post:
I could create a new database using the template in the trunk and then importing the one I exported with this command:
# mysqldump --user=zabbix --password=***** --ignore-table=zabbix.history --ignore-table=zabbix.history_log --ignore-table=zabbix.history_str --ignore-table=zabbix.history_str_sync --ignore-table=zabbix.history_text --ignore-table=zabbix.history_str --ignore-table=zabbix.history_text --ignore-table=zabbix.history_uint --ignore-table=zabbix.history_uint_sync --ignore-table=zabbix.alerts --ignore-table=zabbix.events --ignore-table=zabbix.trends_uint --ignore-table=zabbix.trends zabbix | gzip >/var/zabbix.sql.gz
Is this a good idea?
I know I will lose all my history
I ran several of the sql files in the pathes folder in the trunk and many of them failed.
The webif also showed several routers (all the same make) as suddenly unavailable.
I still don't know if it's the DB-patches that did this or the trunk upgrade itself.
You suggested a procedure in this post:
I could create a new database using the template in the trunk and then importing the one I exported with this command:
# mysqldump --user=zabbix --password=***** --ignore-table=zabbix.history --ignore-table=zabbix.history_log --ignore-table=zabbix.history_str --ignore-table=zabbix.history_str_sync --ignore-table=zabbix.history_text --ignore-table=zabbix.history_str --ignore-table=zabbix.history_text --ignore-table=zabbix.history_uint --ignore-table=zabbix.history_uint_sync --ignore-table=zabbix.alerts --ignore-table=zabbix.events --ignore-table=zabbix.trends_uint --ignore-table=zabbix.trends zabbix | gzip >/var/zabbix.sql.gz
Is this a good idea?
I know I will lose all my history