Categories disappeared

[paulFromWales]

MY client was adding a category and a subcat. then decided to delete the category. From what she told me, the same thing she had done many times before, she deleted the unwanted category and every category on the website was deleted, i checked the DB and it was true, an empty cat. table. What could have caused this and what do i do?

[Kim]

First, restore the back up of the Database. Second, what version of Zen Cart is being used?

[paulFromWales]

version is 1.30 and i am not to sure how to put backup back in. Also backup is quite old so lesson learned. I downloaded a .sql copy of DB and it is just one lone file of text. I only want to put the categories back in PLUS since the back up loads of other stuff has been added but they were not deleted so if i upload .sql file will it effect the stuff added after?

It is strange she had a category i think she added sub cat in it then she clicked on the red cross to delete the cat after, something she had done many times and there were no yellow linked boxes to say products linked and when the sinlge cat selected to delete ALL were deleted, she is not impressed. could it be something or someone doing this or is there a problem, has this happened before or has she clicked on something by accident to link them all, i dont know but I need to know so i can make sure it doesnt happen again...

Help...

Paul

[Website Rob]

Contact your Hoster and explain your backup problem. They might have a recent backup they can provide, from before the db changes were made.

Also, Kim has that 'tutorials' link in her posts for a reason.

[paulFromWales]

Hosting cant help, they back up but dont help individual sites, for mass backup if server problems i guess. Any thought on my issues??

[Ajeh]

Good thing our hosting site does not follow those practices ... or we would be doomed ...