For MySQL, is there tool to dump a set of rows from one tables and all related (by foreign key) rows from all related tables?
I think Jailer is what you are looking for:

http://jailer.sourceforge.net/

(Though I haven't used it so far)