upgrading zabbix: ../mysql/patch.sql with MySQL 5.5: "type" table option doesn't work

XMLWordPrintable

    • Type: Incident report
    • Resolution: Fixed
    • Priority: Minor
    • 1.8.8, 1.9.6 (beta)
    • Affects Version/s: 1.8.5
    • Component/s: None
    • Environment:
      MySQL 5.5

      I recently upgraded a Zabbix 1.4.4 environment to 1.8.5, upgraded MySQL as well. I had to use the ../upgrades/dbpatches/1.6/mysql/patch.sql and .../upgrades/dbpatches/1.8/mysql/patch.sql files from the source tarball.
      Both gave errors, since MySQL 5.5 doesn't use type" table option, instead it uses "ENGINE option.
      Please see http://www.zabbix.com/forum/showthread.php?t=17543 for more details.

      I can't recall MySQL 5.1 gave me these errors. As per http://dev.mysql.com/doc/refman/5.0/en/using-innodb-tables.html , "type" is deprecated. And apparently it doesn't work anymore for MySQL 5.5

            Assignee:
            Unassigned
            Reporter:
            Gertjan Awater
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: