From: Eric Bergen Date: October 24 2012 4:33am Subject: Re: get a partial dump List-Archive: http://lists.mysql.com/mysql/228475 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=20cf307d05283c088404ccc6960f --20cf307d05283c088404ccc6960f Content-Type: text/plain; charset=ISO-8859-1 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 > > -- Eric Bergen eric.bergen@stripped http://www.ebergen.net --20cf307d05283c088404ccc6960f--