Ad Widget

Collapse

Import database problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ipsec
    Junior Member
    • Feb 2020
    • 4

    #1

    Import database problem


    When trying to import a database with command zcat /usr/share/doc/zabbix-server-mysql/create.sql.gz | mysql -u zabbix -p zabbix , get error
    ERROR 1118 (42000) at line 1284: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
  • Glencoe
    Zabbix developer
    • Oct 2019
    • 152

    #2
    What version are you trying to install? The problem's been fixed in 4.4.0

    Comment

    • dimir
      Zabbix developer
      • Apr 2011
      • 1080

      #3
      Correct: https://support.zabbix.com/browse/ZBX-16465

      Comment

      • ipsec
        Junior Member
        • Feb 2020
        • 4

        #4

        I did update zabbix to version 4.0.4 Revision 89349 4 February 2019, but now in /usr/share/doc/zabbix-server-mysql/ the create.sql.gz file is missing.
        What's funny is that after issuing the locate command the system indicates that the create.sql.gz file is in this directory
        Last edited by ipsec; 10-02-2020, 17:06.

        Comment

        • Glencoe
          Zabbix developer
          • Oct 2019
          • 152

          #5
          Originally posted by ipsec
          I did update zabbix to version 4.0.4 Revision 89349 4 February 2019
          You should install 4.4.x, not 4.0.4. It's better to remove all old Zabbix-related packages and install 4.4 from scratch. Go to this page: https://www.zabbix.com/download select Install from packages, then select 4.4, select your distro and versions, then follow the installation steps.

          Comment

          • ipsec
            Junior Member
            • Feb 2020
            • 4

            #6
            Originally posted by Glencoe
            You should install 4.4.x, not 4.0.4. It's better to remove all old Zabbix-related packages and install 4.4 from scratch. Go to this page: https://www.zabbix.com/download select Install from packages, then select 4.4, select your distro and versions, then follow the installation steps.
            Thx . Done

            Comment

            Working...