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='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 !!!
This would be nigh impossible to accomplish in MySQL unless all tables had necessary FOREIGN KEY constraints defined (not guaranteed at all, considering MyISAM doesn't support them).
If all tables DID have the FK's, it would still be quite a task and I don't know of a tool that would export a subset.
I know Navicat will attempt to reverse engineer the relations, but I don't think it will dump a subset of the data.
