Ad Widget

Collapse

mySQL patch 1.8.13 > 2.0 table already exists

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • HullZabbix
    Senior Member
    • Feb 2011
    • 104

    #1

    mySQL patch 1.8.13 > 2.0 table already exists

    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?
  • HullZabbix
    Senior Member
    • Feb 2011
    • 104

    #2
    Just to put an end to this,

    I created a new virtual machine, put CentOS + mysql on there and imported the db, then performed the upgrade, which completed OK. Then imported it in to the zabbix server, so all is well.

    Comment

    Working...