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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
