Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-3843

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

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Minor Minor
    • 1.8.8, 1.9.6 (beta)
    • 1.8.5
    • None
    • 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

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

              Created:
              Updated:
              Resolved: