I think I did something stupid.
I ran:
mysql> update tbl_service set config_name = replace (service_description,'Abcd','Efgh');
and it affected 100+ rows... although I had only one service with a service_description matching 'Abcd'.
It seems like it duplicated a lot of services in the DB (I see many 'Sync Missed' on Nagios)
I still haven't applied configuration.
Can I roll back somehow?
Thanks.
MySQL Replace - oops!
Re: MySQL Replace - oops!
Got it fixed by restoring the DB from /store/backups/mysql/daily/nagiosql/
Thank god you enabled automatic backups by default!
Thank god you enabled automatic backups by default!