Tool to export data with all relational data?
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='condition' 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 !!!