Cannot fill new DB with data.sql (trunk)

XMLWordPrintable

    • Type: Incident report
    • Resolution: Won't fix
    • Priority: Blocker
    • 1.9.0 (alpha)
    • Affects Version/s: 1.9.0 (alpha)
    • Component/s: Installation (I)
    • None
    • Environment:
      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`))
        #

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

              Created:
              Updated:
              Resolved: