Locally I use MAMP on my Macbook to develop Themes for Drupal. There's a nice module called backup & migrate which you can use to get the relevant tables from your Drupal installation.