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
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