ERROR 1005 (HY000) at line 9066: Can't create table '.\bugs\bugs.frm' (errno: 150) Operation failed with exitcode 1
We are facing issue in Bugzilla Upgradation(From 3.6.3 --> 5.0.3).
MYSQL Version : 5.0
Bugzilla : 3.6.3:
This is our existing Production server.
We have taken backup of this data.
Bugzilla 5.0.3 :
Installed new version of Bugzilla 5.0.3 on new server/desktop : Windows
All the installation were successfull.
Localhost URL also opened successfully.
ISSUE : When i am trying to import the backup of Bugzilla 3.6.3 on new
server Bugzilla 5.0.3 thru MYSQL Workbech it ishowing below error :
"ERROR 1005 (HY000) at line 9066: Can't create table '.\bugs\bugs.frm'
Operation failed with exitcode 1 "
PLease advise or provide me steps to resolve.
I need to restore backup taken from 3.6.3 to 5.0.3.