title: Is it possible to dump and import views using mysqldump?
body: <p>When I use mysqldump and the re-import the dump, the views become empty tables.</p>
  
  <p>Is it possible to either </p>
  
  <p>a) dump and then import views without turning them into empty tables?</p>
  
  <p>or, if a is not possible,</p>
  
  <p>b) exclude views from mysqldump with a wildcard, such as </p>
  
  <pre><code>mysqldump mydb  --ignore-table=*views &gt; mydb.sql
  </code></pre>
  
  <p>to exclude all views, if all views have names ending with the string "views"? (this part has been previously asked but remains unanswered: <a href="https://stackoverflow.com/q/8520330/199217">Ignore &#39;views&#39; in mysql db backup using mysqldump</a>) </p>