How-to delete a Product, from bugzilla

Currently bugzilla does not allow you to delete a product, all its components and bugs.

Here's a bunch of steps that you can take to manually delete a product from your bugzilla database.

I am assuming that you have the right to connect to mysql database.
# mysql bugs

1) First determine the id of your product:
select id, name from products;

Let's assume that the id of your product is 4.

2) Verify the bugs which will be deleted. Just make that it is OK to get rid of these bugs.
select bug_id, short_desc from bugs where product_id = 4;

3) Delete all bug related data:
delete from bug_group_map where bug_id in (select bug_id from bugs where product_id = 4);
delete from bugs_activity where bug_id in (select bug_id from bugs where product_id = 4);
delete from cc where bug_id in (select bug_id from bugs where product_id = 4);
delete from flags where bug_id in (select bug_id from bugs where product_id = 4);
delete from keywords where bug_id in (select bug_id from bugs where product_id = 4);
delete from longdescs where bug_id in (select bug_id from bugs where product_id = 4);
delete from votes where bug_id in (select bug_id from bugs where product_id = 4);
delete from bugs where product_id = 4;

4) Delete all product related data:
delete from components where product_id = 4;
delete from flagexclusions where product_id = 4;
delete from flaginclusions where product_id = 4;
delete from group_control_map where product_id = 4;
delete from milestones where product_id = 4;
delete from versions where product_id = 4;

TO DO:

5) Delete groups

6) Delete profile

7) delete user;