title: How can I unset the MAX_ROWS table option on a MyISAM table?
body: <p>I have a table defined as such:</p>
  
  <pre><code>CREATE TABLE `_debug_log` (
    ...
  ) ENGINE=MyISAM AUTO_INCREMENT=896692 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci MAX_ROWS=100000 ROW_FORMAT=COMPRESSED;
  </code></pre>
  
  <p>I'd like to drop the MAX_ROWS option as it isn't necessary for this table, but I do need to keep the existing data. Is there a way to unset this table option via an ALTER statement, or will I need to export the data, rebuild the table and then import the data back in? I checked the MySQL docs on MAX_ROWS, but it only says it requires a positive integer value and doesn't say what the default value is or what a value of 0 might do.</p>