root@zabbix:/opt# mysql -e"create database zabbix;"
root@zabbix:/opt# mysql -e"grant all privileges on zabbix.* to zabbix@localhost identified by 'zabbix';"
root@zabbix:/opt# mysql -D zabbix -uzabbix -p < zabbix-1.9.6/create/schema/mysql.sql
Enter password:
root@zabbix:/opt# mysql -D zabbix -uzabbix -p < zabbix-1.9.6/create/data/data.sql
Enter password:
ERROR 1452 (23000) at line 12212: Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`sysmaps_elements`, CONSTRAINT `c_sysmaps_elements_2` FOREIGN KEY (`iconid_off`) REFERENCES `images` (`imageid`))
root@zabbix:/opt# mysql -e"grant all privileges on zabbix.* to zabbix@localhost identified by 'zabbix';"
root@zabbix:/opt# mysql -D zabbix -uzabbix -p < zabbix-1.9.6/create/schema/mysql.sql
Enter password:
root@zabbix:/opt# mysql -D zabbix -uzabbix -p < zabbix-1.9.6/create/data/data.sql
Enter password:
ERROR 1452 (23000) at line 12212: Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`sysmaps_elements`, CONSTRAINT `c_sysmaps_elements_2` FOREIGN KEY (`iconid_off`) REFERENCES `images` (`imageid`))
Comment