title: Mysqldump only tables with certain prefix / Mysqldump wildcards?
body: <p>I have this huge, messy database I am cleaning up. It houses 500+ tables, which is the result of combining Magento Enterprise with Joomla in one single DB.</p>
  
  <p>To make things worse, there is a set of 70+ Joomla tables that are not in use at all. These are all prefixed with <code>bak_</code>.</p>
  
  <p>Just deleting these <code>bak_</code> tables will be easy, but I want to 'bak' them up first (see what I did there?). In my mind I can picture a command like this:</p>
  
  <pre><code>mysqldump -u username -p mydatabase bak_*
  </code></pre>
  
  <p>But this doesn't work. What would be the best way to do this? Thanks!</p>
  
  <p>EDIT: Yes, I could explicitly list the 70 tables to include, or the ~430 tables to exclude, but I am looking for a better way to do this, if possible.</p>