This is part of The Pile, a partial archive of some open source mailing lists and newsgroups.
Subject: Re: Bugzilla bugs backup and restore problem From: dmose@mozilla.org (Dan Mosedale) Date: 27 Nov 2000 21:28:31 GMT Eric Hanson <ehanson@talkware.net> writes: > Hi, > I am not sure where this question should go but here it is. > > I did a mysqldump of the bugs database, took it to a new machine with > the same mysql version just download and installed by rpm (no > permissions changed yet) and tried to restor it by creating the database > bugs and then piping the dump into a mysql command like so: mysql bugs > < bugs.dump. > Here is the problem. I worked until it got to the bugs_activity > table. At which point it errors out. I have worked on it and figured > out that mysql is choking on the word "when". I tried create a test > table on the machine currently running bugzilla and I could create a > table with a field "when" just fine, tried the same thing on the new > machine, errored out. > Any ideas? Is it a mysql permission thing? Or is my machine on > smack? This is filtered through the haze of my memory, but here's what I think is probably happening: sometime in the 3.23.* series, MySQL started reserving the word "when" for its own use. Your original machine is probably running a version of MySQL prior to that change, and your new machine is probably running a newer version. The thing is, I thought that Terry fixed Bugzilla to no longer use "when" quite a while ago. What version of Bugzilla are you using? === Subject: Re: Bugzilla bugs backup and restore problem From: Eric Hanson <ehanson@talkware.net> Date: Mon, 27 Nov 2000 17:21:59 -0600 Dan Mosedale wrote: > > Eric Hanson <ehanson@talkware.net> writes: > > Hi, > > I am not sure where this question should go but here it is. > > > > I did a mysqldump of the bugs database, took it to a new machine with > > the same mysql version just download and installed by rpm (no > > permissions changed yet) and tried to restor it by creating the database > > bugs and then piping the dump into a mysql command like so: mysql bugs > > < bugs.dump. > > Here is the problem. I worked until it got to the bugs_activity > > table. At which point it errors out. I have worked on it and figured > > out that mysql is choking on the word "when". I tried create a test > > table on the machine currently running bugzilla and I could create a > > table with a field "when" just fine, tried the same thing on the new > > machine, errored out. > > Any ideas? Is it a mysql permission thing? Or is my machine on > > smack? > > This is filtered through the haze of my memory, but here's what I > think is probably happening: sometime in the 3.23.* series, MySQL > started reserving the word "when" for its own use. Your original > machine is probably running a version of MySQL prior to that change, > and your new machine is probably running a newer version. > > The thing is, I thought that Terry fixed Bugzilla to no longer use > "when" quite a while ago. What version of Bugzilla are you using? > > Dan > -- The machine running bugzilla is using version 2.5. I know pretty old. But it has finally come down to me to upgrade. I checked the versions and the msyql's are the same. I think the machine running it was using an old version of mysql and it was upgrade (not a clean one) so that the tables with when were sorta grandfathered in. I have had to modify checksetup.pl a bit, do you think I should submit it? I don't think anyone will upgrade from such as old version so I don't know if there is a point. Eric H. ===