|
|
| (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]]=
| |