title: Export data modified after given date
body: <p>I have a database where each table has two columns that indicate when a table row has been created (<code>gen_date</code>) or modified (<code>mod_date</code>).</p>
  
  <p>I would like to export this complete database (structure) but would like to include only the data modified after a given date.</p>
  
  <p>At the moment I use mysqldump to export the data:</p>
  
  <pre><code>mysqldump --user=username --password=password mydatabase
  </code></pre>
  
  <p>This exports all data and the table definitions.</p>
  
  <p><strong>Question:</strong> Is it possible to export only data with <code>mod_date</code> > some given date?</p>
  
  <p>I was thinking about "cloning" the database and then delete all outdated data and use mysqldump to export the remaining data.</p>
  
  <p>Example of a table:</p>
  
  <pre><code>CREATE TABLE `brand` (
    `id` int(11) UNSIGNED NOT NULL,
    `brand` tinytext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
    `gen_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
    `mod_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  </code></pre>