From within the /upgrades/dbpatches/2.0/mysql folder I've run the following
./upgrade zabbix -u username -p
After running for around 20 minutes it comes back with the following error:
error 1050 (42s01) at line 171: table 'globalvars' already exists
I've searched for previous thread and found that someone had a similar problems going from 1.6>1.8
For the time being I've reverted to a backup. But next time I try does anyone have any idea how to get around this?
e.g.
DROP TABLE IF EXISTS `globalvars`;
then stop mysql service. Remove globalvars.frm /var/lib/myql/zabbix
Any comments?
./upgrade zabbix -u username -p
After running for around 20 minutes it comes back with the following error:
error 1050 (42s01) at line 171: table 'globalvars' already exists
I've searched for previous thread and found that someone had a similar problems going from 1.6>1.8
For the time being I've reverted to a backup. But next time I try does anyone have any idea how to get around this?
e.g.
DROP TABLE IF EXISTS `globalvars`;
then stop mysql service. Remove globalvars.frm /var/lib/myql/zabbix
Any comments?
Comment