title: A non-prepared query using MySQLi and Zend_DB
body: <p>Due to a bug in my servers PDO version, I have switched to using MySQLi. However, this presents another problem, as the <a href="http://framework.zend.com/manual/en/zend.db.html" rel="nofollow noreferrer">Zend_DB</a> <a href="http://framework.zend.com/manual/en/zend.db.html#zend.db.adapter.adapter-notes.mysqli" rel="nofollow noreferrer">MySQLi adaptor</a> doesn't have an exec function. (The <a href="http://framework.zend.com/manual/en/zend.db.html#zend.db.adapter.other-statements" rel="nofollow noreferrer">Zend PDO adaptor did</a>), which means I can't execute a sql script. (Containing a load of DROP TABLE and CREATE TABLE queries).</p>
  
  <p>So where I could just do:</p>
  
  <pre><code>$sqlQuery = file_get_contents('schema.sql');
  $db = Zend_Db_Table_Abstract::getDefaultAdapter();
  $db-&gt;exec($sqlQuery);
  </code></pre>
  
  <p>I can't find a way to do this using the Zend MySQLi Adaptor. Any ideas?</p>