I am installing new bugzilla server and importing old database to new bugzilla server
old mysql Server version : mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (x86_64) using readline 5.2
old OS Version: Debian GNU/Linux 5.0 \n \l
New Mysql Server Version : mysql Ver 14.14 Distrib 5.5.49, for debian-linux-gnu (x86_64) using readline 6.3
New OS Version: Debian GNU/Linux 8 \n \l
I am importing database like below
mysql -u root -p bugs < /home/chelsio/backup-05-25-2016-19-00.sql
I am getting below error
ERROR 1005 (HY000) at line 6237: Can't create table 'bugs.bugs' (errno: 150).
SHOW ENGINE INNODB STATUS; output
LATEST FOREIGN KEY ERROR
160527 10:27:59 Error in foreign key constraint of table bugs/bugs:
FOREIGN KEY (component_id) REFERENCES components (id) ON UPDATE CASCADE,
CONSTRAINT fk_bugs_product_id_products_id FOREIGN KEY (product_id) REFERENCES products (id) ON UPDATE CASCADE,
CONSTRAINT fk_bugs_reporter_profiles_userid FOREIGN KEY (reporter) REFERENCES profiles (userid) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=30401 DEFAULT CHARSET=utf8:
Cannot find an index in the referenced table where the
referenced columns appear as the first columns, or column types
in the table and the referenced table do not match for constraint.
Note that the internal storage type of ENUM and SET changed in
tables created with >= InnoDB-4.1.12, and such columns in old tables
cannot be referenced by such columns in new tables.
I dont have any knowledge on mysql I am new mysql world. Please help.
