Bugzilla:FAQ:Bugzilla Database: Difference between revisions

From MozillaWiki
Jump to navigation Jump to search
(Bugzilla:FAQ 6. Bugzilla Database)
 
(Replaced content with 'See Bugzilla:FAQ#Database.')
 
(3 intermediate revisions by 3 users not shown)
Line 1: Line 1:
=[[Bugzilla:FAQ:General_Questions|General Questions]]=
See [[Bugzilla:FAQ#Database]].
=[[Bugzilla:FAQ:Managerial_Questions|Managerial Questions]]=
=[[Bugzilla:FAQ:Administrative_Questions|Administrative Questions]]=
=[[Bugzilla:FAQ:Bugzilla_Security|Bugzilla Security]]=
=[[Bugzilla:FAQ:Bugzilla_Email|Bugzilla Email]]=
=[[Bugzilla:FAQ:Bugzilla_Database|Bugzilla Database]]=
 
==I think my database might be corrupted, or contain invalid entries. What do I do?==
Run the "sanity check" utility (sanitycheck.cgi) from your web browser to see!
If it finishes without errors, you're probably OK.
If it doesn't come back OK (i.e. any red letters),
there are certain things Bugzilla can recover from and certain things it can't.
If it can't auto-recover, I hope you're familiar with mysqladmin commands
or have installed another way to manage your database.
Sanity Check, although it is a good basic check on your database integrity,
by no means is a substitute for competent database administration
and avoiding deletion of data.
It is not exhaustive, and was created to do a basic check
for the most common problems in Bugzilla databases.
 
==I want to manually edit some entries in my database. How?==
There is no facility in Bugzilla itself to do this.
It's also generally not a smart thing to do if you don't know exactly what you're doing.
If you understand SQL, though,
you can use the '''mysql''' command line utility to manually insert,
delete and modify table information.
There are also more intuitive GUI clients available.
Personal favorites of the Bugzilla team are
[http://www.phpmyadmin.net/ phpMyAdmin] and
[http://www.mysql.com/products/mysqlcc/ MySQL Control Center].
 
Remember, backups are your friend.
Everyone makes mistakes, and it's nice to have a safety net in case you mess something up.
Consider using '''mysqldump''' to make a duplicate of your database
before altering it manually.
 
==I think I've set up MySQL permissions correctly, but Bugzilla still can't connect.==
Try running MySQL from its binary: mysqld --skip-grant-tables.
This will allow you to completely rule out grant tables as the cause of your frustration.
If this Bugzilla is able to connect at this point then you need to check
that you have granted proper permission to the user password combo defined in localconfig.
*Running MySQL with this command line option is very insecure and should only be done when not connected to the external network as a troubleshooting step.
 
==How do I synchronize bug information among multiple different Bugzilla databases?==
Well, you can synchronize or you can move bugs.
Synchronization will only work one way --
you can create a read-only copy of the database at one site,
and have it regularly updated at intervals from the main database.
 
MySQL has some synchronization features built-in to the latest releases.
It would be great if someone looked into the possibilities there
and provided a report to the newsgroup on how to effectively synchronize two Bugzilla installations.
 
If you simply need to transfer bugs from one Bugzilla to another,
checkout the "move.pl" script in the Bugzilla distribution.  
 
=[[Bugzilla:FAQ:Bugzilla_and_Win32|Bugzilla and Win32]]=
=[[Bugzilla:FAQ:Bugzilla_Usage|Bugzilla Usage]]=
=[[Bugzilla:FAQ:Bugzilla_Hacking|Bugzilla Hacking]]=

Latest revision as of 13:27, 19 March 2010

See Bugzilla:FAQ#Database.

Retrieved from "https://wiki.mozilla.org/index.php?title=Bugzilla:FAQ:Bugzilla_Database&oldid=209826"