title: Mysql: ALTER TABLE and foreign keys
body: <p>I'm trying to do</p>
  
  <pre><code>ALTER table tbl_name Engine=MyISAM;
  </code></pre>
  
  <p>and I get </p>
  
  <pre><code>ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails
  </code></pre>
  
  <p>How can I perform above query without deleting table having foreign key?</p>
  
  <p>Thank you in advance!</p>
  
  <p><strong>UPD</strong> have I understood correctly that only <code>MyIsam</code> supports fulltext search?</p>