Skip to Main Content

MySQL Database

Migarting old Database to new Database mysql and getting error

2686597May 27 2016 — edited May 31 2016

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.

Comments
Post Details
Added on May 27 2016
3 comments
803 views