Can I undo damage I caused with CSV import?

[paciocco]

I did a bad thing. I've always enjoyed the convenience of using CSV imports for mass editing, and I had always had the good sense to avoid including the short and long description in those CSVs as it would eliminate all the formatting I had done on those elements.

 

Recently however I found a module that makes CSV exports, and it exported these descriptions in the HTML code. So I became overconfident and tried to upload the HTML code back in via CSV import. It didn't work, and I essentially erased most of my descriptions. And because I'm extra stupid I didn't even bother to do a database backup before uploading this CSV.

 

So, first question:

 

Can someone give me a quick heads up where to figure out how to restore from a database backup I made through the BO? I've looked around a little and I've been a little intimidated by the process I'd seen described.

 

Bigger question:

 

It seems from other threads here that uploading HTML code via the CSV doesn't really work. But it did work- a little. Maybe half of the short descriptions worked fine- it read all the HTML code fine- proper font and everything. My long descriptions (which are generally very long- 2000+ characters) almost never worked at all, or were cut very short. For a variety of reasons I would strongly prefer to be able to correct these descriptions by inputting the HTML into a CSV. Anyone know a way to make it work?