How can I export a subset of tabledata from a prodution database into my local testing database?
I haven't used this tool, but Jailer promises to do just that


  Database Subsetting and Browsing Tool. Exports consistent, referentially intact row-sets from relational databases (JDBC)


http://sourceforge.net/projects/jailer/