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

Cannot fill new DB with data.sql (trunk)

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Won't fix
    • Icon: Blocker Blocker
    • 1.9.0 (alpha)
    • 1.9.0 (alpha)
    • Installation (I)
    • None
    • trunk rev 14502
      FreeBSD 8.1-RELEASE #0
      mysql-server-5.5.5_1

      mysql> create database zabbix2 character set utf8;
      Query OK, 1 row affected (0.00 sec)

      mysql> exit
      Bye

      1. cd create/schema
      2. cat mysql.sql | mysql zabbix2
      3. cd ../data
      4. cat data.sql | mysql zabbix2
        ERROR 1452 (23000) at line 12201: Cannot add or update a child row: a foreign key constraint fails (`zabbix2`.`sysmaps_elements`, CONSTRAINT `c_sysmaps_elements_2` FOREIGN KEY (`iconid_off`) REFERENCES `images` (`imageid`))
        #

            Unassigned Unassigned
            zalex_ua Oleksii Zagorskyi
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: