mysqldump - subset of tables with foreign keys

I would like to dump out only the schema of a few tables that I have in
a mysql db. But in addition I would like the returned schema to not
reference any table (via foreign keys) that is not dumped.

The basic idea is to create a subset of tables using mysqldump that is
self-contained and has no external constraints.

any easy ways to do it ?? plz. help ..

Re: mysqldump - subset of tables with foreign keys

i know you can do this with some third party apps such as webyog.

muthuprasanna@gmail.com wrote:
> I would like to dump out only the schema of a few tables that I have in
> a mysql db. But in addition I would like the returned schema to not
> reference any table (via foreign keys) that is not dumped.
>
> The basic idea is to create a subset of tables using mysqldump that is
> self-contained and has no external constraints.
>
> any easy ways to do it ?? plz. help ..
>