title: MySQL Administrator Backups: "Compatibility Mode", What Exactly is this doing?
body: <p>In Mysql Administrator, when doing backups, what exactly is "Compatibility Mode"? </p>
  
  <p>I'm trying to bridge backups generated by <a href="http://www.webmin.com/" rel="nofollow noreferrer">webmin</a> with the upload tool available inside <a href="http://www.mysql.com/products/tools/administrator/" rel="nofollow noreferrer">mysql administrator</a>. My data already has a couple of inconsistencies (ticks, commas, etc, I think) I just wont try to kink out (they might just reappear in the future anyways). These kinks generate errors when I try to restore out of my backups.</p>
  
  <p>Now, if I generate backups from webmin, and then use MySQL administrator to restore them, they fail. But if I generate the backups using MySQL Administrator AND tick "Compatibility Mode", then head over to MySQL administrator (another instance) and restore... it works! </p>
  
  <p>According to MySQL, "Compatibility Mode" is;</p>
  
  <blockquote>
    <p>Compatibility mode creates backup files that are compatible with older versions of MySQL Administrator. </p>
  </blockquote>
  
  <p>Webmin, on the other hand, gives me the following options for compatibility:</p>
  
  <ul>
  <li>ANSI</li>
  <li>MySQL 3.2.3</li>
  <li>MySQL 4.0</li>
  <li>PostgreSQL</li>
  <li>Oracle</li>
  <li>Microsoft SQL</li>
  <li>DB2</li>
  <li>MaxDB</li>
  </ul>
  
  <p>Which would you say is a best fit? My data set is very large, so it would take quite some time to experiment one by one (specially whence thinking might beat brute-forcing it).</p>
  
  <p>Edit: seems like it's doing ANSI, but i'm not 100% on it.</p>