Contrib/ Bugzilla Stripping Tool

Joel Peshkin bugreport at peshkin.net
Tue Jul 8 17:16:40 UTC 2008


Hi All:

   I'm just in the process of splitting of a set of products that have 
been sold to another company so that there is a copy of the original 
company's Bugzilla containing only the subset of products being sold.

   At the moment, the approach is to
   1) Make a copy
   2) Rename all the products that do NOT go with the new company to 
start with "BYE_"
   3) Run a script full of mysql commands that systematically delete the 
rows of all the tables that are associated with those products' bugs' 
attachment's data, then products' bugs' attachments, then products' 
bugs' longesc, etc......

   I'm doing this for 2.22.*'s schema.  

   I am wondering if this is something that should be made into a more 
general capability and kept up to date as the schema evolves.   If so, I 
would probably use a mechanism like "closed for bug entry" instead of 
renaming the products to indicate which ones should go away. Any thoughts?

-Joel




More information about the developers mailing list