ERROR 1005 (HY000) at line 9066: Can't create table '.\bugs\bugs.frm' (errno: 150) Operation failed with exitcode 1

[praveen kumar]

Hello Team,

We are facing issue in Bugzilla Upgradation(From 3.6.3 --> 5.0.3).
MYSQL Version : 5.0
Apache 2.4

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
10(for testing).
All the installation were successfull.
Localhost URL also opened successfully.: http://localhost:8080/

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'
(errno: 150)
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.

Thanks,
Praveen
[phone]

[praveen kumar]

Hello Team,

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
10(for testing).
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'
(errno: 150)
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.

Thanks,
Praveen
[phone]

[Thorsten Schöning]

Guten Tag praveen kumar,

Post by praveen kumar
ISSUE : When i am trying to import the backup of Bugzilla 3.6.3 on new
"ERROR 1005 (HY000) at line 9066: Can't create table '.\bugs\bugs.frm'
(errno: 150)
Operation failed with exitcode 1 "

Did you empty the existing database or tried to restore to a new one?
If not, the table "bugs" simply exists already and might therefore not
be created.

If that doesn't help, I suggest to google for that error, because it
might have a lot of very different reasons and in theory you need to
test each of it until your problem is resolved. We can't know all the
possible issues. :-)

Additionally, keep the following in mind:

https://bugzilla.readthedocs.io/en/5.0/installing/moving.html

In your case, though,

Mit freundlichen Grüßen,

Thorsten Schöning
--
Thorsten Schöning E-Mail: ***@AM-SoFT.de
AM-SoFT IT-Systeme http://www.AM-SoFT.de/

Telefon...........05151- 9468- 55
Fax...............05151- 9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow