Associating products with categories within the database

Sorry for the double post. I think my post is better described here. Trying to deleted other post.

I created a small problem for myself. I accidentally created a category with a subcategory within it. Within the subcategory i have about 22 products.

I wanted to get rid of the subcategory so I deleted it. I backed up the 22 products and when I deleted the subcategory the products were deleted as well. So I went into the database and inserted the backed up products.

The products arent showing up within the zen admin section or the site, but are showing up within the database. I changed the master_categories_id within each product to match the main category I have thinking it would associate each product with the category, but still not showing within the zen cart admin, or the site.

I'm sure i'm missing something somewhere and figured i'd write to see if someone could point me in the right direction.

Sl,
Please be patient for an answer & don't double post... Read the tutorials on posting a thread please

Yeah i know. Sorry about that. Just thought it would do better here. Even for people looking for solutions to the same issues. Again, sorry. :oops:

I figured it out. So basically I exported my products from the products table, but failed to backup the product_description, and the products_to_categories tables.

In order for your products to be available in a particular category those three tables rely on each other.

Lesson learned.