Sometimes the unthinkable happens.
Someone on the team, (or maybe even yourself) hit the wrong button. They've deleted a bunch of products. Or they've imported a bunch of bad data that has overwritten valuable product data.
So what do you do? You simply take your backup and restore it, right? There is only one problem. If you do a full restore of the database from the night before, you are losing everything up until that point. This includes new customers, orders, reviews, etc. You only really want the catalog restored. So we can open up our sql dump and grab what we want. If your export file isn't too big, that's not a problem. If it is Gigabytes large, (which in Magento world is all too common), opening it and dissecting it is going to be a near impossibility.