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 ..
muthuprasanna [ Di, 31 Oktober 2006 00:24 ] [ ID #1518091 ]

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 ..
>
larko [ Di, 31 Oktober 2006 15:26 ] [ ID #1519352 ]
Datenbanken » mailing.database.mysql » mysqldump - subset of tables with foreign keys

Vorheriges Thema: more balance performance
Nächstes Thema: failing to import an export from phpMyAdmin