title: DROP TABLE before view definition incorrect in mysqldump output
body: <p>I have a mysql database on a shared web host. Some of the tables are rather large, and our nightly dump process was getting killed. So I made a script that queried the database for all the table names , and dumped them individually, concatenating them all into a single file. </p>
  
  <pre><code>mysql -uusername -ppassword -hhostname dbname &lt; &lt;(echo 'SHOW TABLES') | xargs -I TableName sh -c 'nice -19 mysqldump --opt -uusername -ppassword -hhostname dbname TableName &gt;&gt; /path/to/dump.sql'
  </code></pre>
  
  <p>I have the problem now where one of the view definitions (as I understand, MySQL has idiosyncratic view creation statements in its dump file) causes the error </p>
  
  <pre><code>ERROR 1146 (42S02) at line 5182: Table 'dbname.vView' doesn't exist
  </code></pre>
  
  <p>I looked up line 5182 in the dump file and it's this first line, which begins the creation of the view:</p>
  
  <pre><code>/*!50001 DROP TABLE `vView`*/;
  /*!50001 DROP VIEW IF EXISTS `vView`*/;
  /*!50001 CREATE ALGORITHM=UNDEFINED */
  </code></pre>
  
  <p>Yet for whatever reason, other views in the dump file have</p>
  
  <pre><code>/*!50001 DROP TABLE IF EXISTS `vOtherView`*/;
  </code></pre>
  
  <p>And they get created okay. </p>
  
  <p>Following this <a href="https://stackoverflow.com/questions/6128286/innodb-tables-exist-in-mysql-but-says-they-do-not-exist-after-copying-database-t">question</a>, I tried <code>mysql -f</code> when importing the dump, but mysql still halted on the error. </p>
  
  <p>How can I get the dump file to have a properly formatted view creation statement (outside of doing some post-processing of the dump file)? Or how can I get mysql to forge ahead regardless?</p>