List:General Discussion« Previous MessageNext Message »
From:Stefan Kuhn Date:October 18 2012 8:33pm
Subject:Re: get a partial dump
View as plain text  
Ok, but I can't trace foreign key references, can I? Plus I can't run this 
from Java (well, I can, but it's cumbersome)?
But thanks for the hint
Stefan


On Wednesday 24 October 2012 05:33:22 Eric Bergen wrote:
> mysqldump has a --where argument that allows you to pass in a where clause.
>
> On Thursday, October 18, 2012, Stefan Kuhn wrote:
> > Hi everybody,
> > I want to get insert statements from a mysql database for a number of
> > rows of
> > a table, specified by a where clause. I also need the inserts for the
> > datasets linked via foreign keys in other tables. So I need a sort of
> > partial
> > dump, a bit like mysqldump, but restricted to a (small) set of data. This
> > needs to be done in a Java program, using mysql via jdbc.
> > Does anybody know an easy way to do this? Of course I could build the
> > statements in the java code, but I thought mysql might offer that or at
> > least
> > parts of it. Does anybody have an idea?
> > Thanks,
> > Stefan
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:    http://lists.mysql.com/mysql


Thread
get a partial dumpStefan Kuhn22 Oct
  • Re: get a partial dumpEric Bergen24 Oct
    • Re: get a partial dumpStefan Kuhn24 Oct
  • Re: get a partial dumpbars0.bars0.bars026 Oct