Tool to export data with all relational data? Is there a tool to export data from selected rows in a table with all data stored in other tables in other tables linked by relational design?

The purpose is to ease migrations of bits of data between servers for adhoc migrations. I am looking specifically for a tool for MySQL InnoDB with defined foreign keys.
In reality, you could just script it yourself using mysqldump.

Here my posts using the --where option for mysqldump:


Aug 15, 2011 : Is it possible to mysqldump a subset of a database required to reproduce a query?
Mar 14, 2012 : Can I mysqldump an entire database while using where=&#39;condition&#39; on individual tables?
Jul 15, 2013 : Export just rows modified in last month (date defined by user)


With a good review of your tables and some SQL elbow grease, you can script the dump for any table and its child records with the corresponding foreign key references.

Give it a Try !!!