One of the most time consuming, and frustrating tasks (purely becuase it is so mundane) is for a developer is to export external system databases, and re-import them for debug work.
In magento land, you need to alter a lot of database config values to make the imported database run in your dev environment.
This article describes a snaphot tool I created to allow quick, easy import and export of external magento databases into my development environment.
Read More