How to migrate bugzilla 2.20 database to 3.0

 
Currently I am using Bugzilla 2.20 and want to upgrade it to ver. 3.0.
After clean installation for Bugzilla 3.0, how to migrate mysql database
from 2.20 to 3.0
 
With Regards,
Charan
 
0
Charanjit
5/30/2007 5:16:58 AM
mozilla.support.bugzilla 10158 articles. 0 followers. Post Follow

6 Replies
585 Views

Similar Articles

[PageSpeed] 52

Charanjit Singh escribi�:
> Currently I am using Bugzilla 2.20 and want to upgrade it to ver. 3.0.
> After clean installation for Bugzilla 3.0, how to migrate mysql database
> from 2.20 to 3.0

http://www.bugzilla.org/docs/3.0/html/upgrading.html

Regards,

	Andr�s	[ knocte ]

-- 
0
ISO
5/30/2007 7:28:32 AM
> http://www.bugzilla.org/docs/3.0/html/upgrading.html
>
> Regards,

That just covers upgrading.  In my case, I would like to change
servers as well. The old server is 2.22 and the new one is now 3.0.  I
would like to move all the bugs, products, components etc to the new
server.

0
mesa_1964
5/30/2007 9:20:16 PM
What you would do is mysqldump your original database and then load it
into your new server.  Upgrade/install bugzilla to 3.0 and then run
checksetup.pl.

The checksetup.pl script will automatically upgrade your older
database to the 3.0 structure.  It may require a few tries due to
missing CPAN modules or possible inconsistencies in your database.
But the script will inform you of any errors.

Just backup your original database in case there is any problems.

On 30 May 2007 14:20:16 -0700, mesa_1964@yahoo.ca <mesa_1964@yahoo.ca> wrote:
>
> > http://www.bugzilla.org/docs/3.0/html/upgrading.html
> >
> > Regards,
>
> That just covers upgrading.  In my case, I would like to change
> servers as well. The old server is 2.22 and the new one is now 3.0.  I
> would like to move all the bugs, products, components etc to the new
> server.
>
> _______________________________________________
> support-bugzilla mailing list
> support-bugzilla@lists.mozilla.org
> https://lists.mozilla.org/listinfo/support-bugzilla
> PLEASE put support-bugzilla@lists.mozilla.org in the To: field when you reply.
>
0
Albert
5/30/2007 9:33:06 PM
On May 30, 2:33 pm, "Albert Ting" <altl...@gmail.com> wrote:
> What you would do is mysqldump your original database and then load it
> into your new server.  Upgrade/install bugzilla to 3.0 and then run
> checksetup.pl.
>
> The checksetup.pl script will automatically upgrade your older
> database to the 3.0 structure.  It may require a few tries due to
> missing CPAN modules or possible inconsistencies in your database.
> But the script will inform you of any errors.
>
> Just backup your original database in case there is any problems.
>

I'm in a big mess, old bugzilla server croked, but I have all the data
files as well as several dumps of db. I've recently installed a new OS
(RHEL4) on a newer server, installed all Perl modules I could (left
optional problematic ones out), ran .checksetup.pl and completed okay.
Now I'm trying to restore backed-up dump-backup.sql file and I get
errors.

I wish this was much easier or perhaps I'm making it harder than it
should be:
==========================================================

[root@filer mysql]# mysql -uroot -prootpassword bugs < db_bugs-
backup_03172007.sql
ERROR 1146 (42S02) at line 12: Table 'bugs.attachments' doesn't exist
[root@filer mysql]#

I've been looking at mysql commands all day since I really don't know
any mysql, although I can get by with manuals and step-by-step howtos.
So forgive me if newbit mysql user.

Please send help, S.O.S...

0
gmarquez
5/31/2007 5:05:55 AM
> I wish this was much easier or perhaps I'm making it harder than it
> should be:
> ==========================================================
>
> [root@filer mysql]# mysql -uroot -prootpassword bugs < db_bugs-
> backup_03172007.sql
> ERROR 1146 (42S02) at line 12: Table 'bugs.attachments' doesn't exist
> [root@filer mysql]#
>

Okay so I did several things to attempt to correct this:
I copied my old localconfig file, then ran the .checksetup script and
it appeared to incorporate many of the old settings as expected. I
then copied the entire OLD /var/www/html/bugzilla directory to the new
location, which takes care of all the web pages being the same as
before. Now I'm still getting stuck at importing the backed up mysql
dump backup file to the bugs databse:
=============================================================
[root@filer ~]# mysql -uroot -prootpassword bugs < /cm-recover/dumps/
mysql/db_bugs-backup_03172007.sql
ERROR 1136 (21S01) at line 12: Column count doesn't match value count
at row 1
[root@filer ~]#
=============================================================

Is this the same issue as before or completely different?????
Please advise.

0
gmarquez
5/31/2007 6:52:01 AM
I fixed it thanks to Max to answering my other post:
http://groups.google.com/group/mozilla.support.bugzilla/browse_thread/thread/4e73b5d9904f5d04/ca291de61eb8302b?lnk=gst&q=upgrade&rnum=5#ca291de61eb8302b

He explained my mysqldump command was incorrect:

> For the dumps, I use the following:
> #mysqldump -uroot -pmysqlroot -n -t bugs > /dumps/mysql/db_bugs-
> backup_03172007.sql

I'll never use the '-t' option ever again!!! This was my problem,
luckily I had a copy of my database files from /var/lib/mysql/bugs and
just copied all those again and re-ran checksetup.pl.

Good luck...

-Regards,
GMarquez

0
FuRoSh
5/31/2007 11:32:52 PM
Reply:

Similar Artilces:

Problem migrating database from bugzilla 2.20.2 to bugzilla 3.0
hi all, I installed bugzilla 3.0 and was working fine till I tried migrating the mysql db from previous version of bugzilla 2.20.2. These two versions are on different machines. I created .dmp file to get the data in bugzilla 2.20.2 to update it to bugzilla 3.0. Tables seemed to be updated(not sure if there is mismatch between the table structure), but after that upon trying to run checksetup.pl script, I am getting the following message ------------------------------------------------ "There was an error connecting to MySQL: Access denied for user 'bugs'@'localh...

Issue With Migrating Bugzilla 3.0.5 to Bugzilla 4.0.2
ERROR: There are invalid values for the assigned_to column in the bugs table. (These values do not exist in the profiles table, in the userid column.) Before continuing with checksetup, you will need to fix these values, either by deleting these rows from the database, or changing the values of assigned_to in bugs to point to valid values in profiles.userid. The bad values from the bugs.assigned_to column are: 13, 16, 22, 23, 38, 40 On 01/12/11 11:33, Krishnaraj B wrote: > ERROR: There are invalid values for the assigned_to column in the bugs > table. (These values do not exist...

Migrating Bugzilla 2.20 to Bugzilla 3
Hi everyone, I'm new in the list but I'd like to say how such a good work you have done on this version of Bugzilla. I'm using bugzilla 2.20 but tried to upgrade it to bugzilla 3 but unfortunately just export the database of Bugzilla 2.20 to Bugzilla 3 database didn't worked. I'm looking for at web but I've get any result yet. Thanks, -- Leonardo A. M. dos Santos HST Sistemas & Tecnologia Service Desk - Fábrica de Softwares Fone: +55 19 3294-0331 www.hst.com.br ...

Security Advisory for Bugzilla 3.0.3, 3.1.3, 2.22.3, and 2.20.5
--Sig_/7+QS=YT68me2o8pI2lL1LPd Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Summary =3D=3D=3D=3D=3D=3D=3D Bugzilla is a Web-based bug-tracking system, used by a large number of software projects. This advisory covers three security issues that have recently been fixed in the Bugzilla code: * Users without the "canconfirm" privilege could enter a bug as NEW or ASSIGNED by using the XML-RPC interface. * When viewing several bugs at once, there was a Cross-Site Scripting hole. * The inbound email interface allowed you t...

Migrating the Bugzilla database from 2.20.5 to 3.1.3
Hello; I have been searching for a utility, Perl script, etc., to assist in migrating the Bugzilla database from 2.20.5 to 3.1.3.=20 Will move.pl work for this? Do I need to CVS?=20 Any help will be appreciated,=20 Thank you, Bruce Grant On 6/24/2008 11:41 AM, Grant, Bruce J wrote: > Hello; I have been searching for a utility, Perl script, etc., to assist > in migrating the Bugzilla database from 2.20.5 to 3.1.3. That's what checksetup.pl is for. ...

upgrade bugzilla and migrate database from 2.16.3 to 2.20
Hi group, i tried to migrate our bugzilla installation (suse linux) from version 2.16.3 to 2.20. I used the CVS upgrade and it seemed to work perfect. The check checksetup.pl script dedected errors in the database (mysql). Droping the database and running the checksetup spript worked fine, but I want to migrate the existing database to version 2.20. I did not find any HOWTO. Can anybody help? regards Thomas Mayer Thomas Mayer wrote: > i tried to migrate our bugzilla installation (suse linux) from version > 2.16.3 to 2.20. I used the CVS upgrade and it seemed to ...

P4DTI 2.3.0 released to support Bugzilla 2.20
I have made release 2.3.0 of the Perforce Defect Tracking Integration (P4DTI): <http://www.ravenbrook.com/project/p4dti/release/2.3.0/> This release works with Bugzilla 2.20 and with Perforce servers in Unicode mode, and the User's Guide includes instructions for P4V users. This release has not yet been approved by Perforce Inc. As and when it is approved, it will be uploaded to the Perforce public repository. Unless and until it is approved, it is not a supported product of Perforce Inc. In the meantime, I welcome feedback from anyone prepared to try this release...

RE:upgrade bugzilla and migrate database from 2.16.3 to 2.20
We are trying to do the same thing. I tried this from another post: have migrated my *Bugzilla **2.16* to *Bugzilla* 2.19.2 as follow: - on the *2.16* -> % mysqldump -u root -p --opt --all bugs > bugs.sql - copy the bugs.sql to the new server (2.18) - rename bugs on the new server (2.18) - % mysqladmin create bugs - % mysql bugs < bugs.sql - % mysqladmin flush-privileges - % ./checksetup.pl - % ./collectstats.pl bug the checksetup.pl script errored out and gives me this message DBD::mysql::st execute failed: Unknown column 'groups.id' in 'field list'...

Testopia 1.3 (Bugzilla 3.0) and Testopia 1.2.2 (Bugzilla 2.22.x) Released
Testopia 1.3 has been released.=20 This Testopia is compatible with Bugzilla 3.0 and mod_perl and provides Postgres support. For those of you still running Bugzilla 2.22.x, I am also releasing 1.2.2 which is a (major) bug fix release. They are available from the project home page at http://www.mozilla.org/projects/testopia Thanks for all the feedback. Keep it coming. Greg Hendricks ...

[ANN] Release of Bugzilla 3.0.1, 3.1.1, 2.22.3, and 2.20.5
--Sig_nEH4Ypdt2vWEVOYyO6=XaoK Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Today the Bugzilla project has four releases! 3.0.1 is the first bug-fix release for the 3.0 series. 3.0 was very stable, but 3.0.1 adds a lot of little polish fixes that greatly improve the experience of using Bugzilla. 3.1.1 is our first development release toward Bugzilla 3.2. It has a huge number of new features, but is EXTREMELY UNSTABLE. It has not been tested, and should not be used in a production environment. It may fail in critical ways, or destro...

[ANN] Release of Bugzilla 3.2.2, 3.0.8, and 3.3.3
Bugzilla 3.2.1, 3.0.7, and 3.3.2 contained a bug that was critical for any installation running under mod_perl, due to an unintentional interaction between the various security fixes in those releases. We are releasing three new releases today to fix the critical issue: 3.2.2, 3.0.8, and 3.3.3. They are identical to the previous release except that they have this one fix for installations running under mod_perl. Download -------- Bugzilla is available at: http://www.bugzilla.org/download/ Security Advisory ----------------- Details of the fix are in the Security Adviso...

[ANN] Release of Bugzilla 3.2.1, 3.0.7, 2.22.7, and 3.3.2
Today we have some major security improvements for Bugzilla in the form of four releases. We strongly recommend that all Bugzilla administrators read the Security Advisory for these releases, which is linked below in this email. Bugzilla 3.2.1 is our latest stable release. It contains various useful bug fixes in addition to major security improvements. Bugzilla 3.0.7 and Bugzilla 2.22.7 are security updates for their branches. Bugzilla 3.3.2 is an unstable development release. In addition to the security fixes that all the other releases contain, this release contains n...

[ANN] Release of Bugzilla 3.0.4, 3.1.4, 2.22.4, and 2.20.6
--Sig_/APAQZZ+qGwu.Hq/UgkhiOAo Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable The Bugzilla project has four releases today! Bugzilla 3.0.4 is the latest stable version of Bugzilla, containing several useful bug fixes over 3.0.3, particularly for the inbound email interface. Bugzilla 3.1.4 is our latest unstable development preview. It should be more stable than 3.1.3, though we still don't recommend it for production environments. Provided we don't find too many major issues in this release, our next release will be Bugzilla...

Bugzilla Upgrade
Hi Support Team, =20 I plan to upgrade from Bugzilla 3.0.3 to 3.2.2 . Our bugzilla setup has a lot of "Custom fileds" .=20 I went thro' the upgrade notes but that does not explicitly=20 mention about the steps that I need to follow with "Custom Fields".=20 Do I need to copy some files from template/en/custom to the new location ? Please let me know the steps that I need to follow for the upgrade with custom fields.=20 =20 Thanks for your help! -J ...

Web resources about - How to migrate bugzilla 2.20 database to 3.0 - mozilla.support.bugzilla

Bugzilla - Wikipedia, the free encyclopedia
Bugzilla is a Web -based general-purpose bugtracker and testing tool originally developed and used by the Mozilla project, and licensed under ...

Bugzilla Main Page
This is the bug tracker for MediaWiki and its extensionsand site-specific problems on Wikimedia's wiki sites. Welcome to Bugzilla. To see what's ...

Critical Bugzilla vulnerability could give hackers access to undisclosed software flaws
Hackers could have had an inside track on unpatched flaws in major software projects because of a critical vulnerability in Bugzilla, a system ...

Bugzilla 0-day can reveal 0-day bugs in OSS giants like Mozilla, Red Hat
C Security firm Check Point Software Technologies used a flaw it discovered in the Perl programming language to hack into the popular Bugzilla ...

Mozilla loses more user info, this time data of 97,000 customers goes out through Bugzilla
... has come to light regarding the loss of another 97,000 emails and passwords that were left exposed. The latest issue comes via Bugzilla, and ...

Bugzilla, my first wiki
Bugzilla introduced me to the world of wikis. It took me a while to understand the power of wikis. But I remember years ago when I first used ...

Mozilla's Bugzilla Hacked, Exposing Firefox Zero-Days
The good news in this bad situation is that Firefox is already patched for all the issues.

Bugzilla Zero-Day Exposes Zero-Day Bugs
A previously unknown security flaw in Bugzilla — a popular online bug-tracking tool used by Mozilla and many of the open source Linux distributions ...

Critical Bugzilla vulnerability could give hackers access to undisclosed software flaws
Hackers could have had an inside track on unpatched flaws in major software projects because of a critical vulnerability in Bugzilla, a system ...

Bugzilla API - ProgrammableWeb
Bugzilla is the bug tracking and reporting system created and used by Mozilla. It is also available for use by other projects and organizations. ...

Resources last updated: 11/23/2015 9:45:04 PM