Delete a categrory from database

[caroline08]

Hi,

I wanted to delete a category, but I forgot to delete it from the admin page. What I did is I simply delete the category from the category table in mysql database. Actually there are a lot more tables have this category information. How can I delete all the rows which related to this category? Can somebody help me? It's urgent! Thanks a lot!!!

[perlgerl]

The category_id appears in tables categories, categories_descriptions, products_to_categories and possibly meta_tags_categories_description.

If you can determine the deleted categories_id (perhaps from one of the other tables) it might be easier to restore the categories_id, parent_id, and categories_status = 1 in table categories, and then delete it properly from Admin > Catalog > Categories/Products.