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 [at] 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 ..
>