title: MySQL export indices
body: <p>I'm sure it must have been asked before, but I can't find it:</p>
  
  <p>I have a CMS that is under constant development. I have built a number of websites using the CMS, so their are a number of databases in existence.</p>
  
  <p>I want to extract the indices from the development db and apply them to the production dbs. Is there an easy way to extract indices as SQL?</p>
  
  <p>Something along the lines of:</p>
  
  <pre><code>create index idx1 on one (lft, rght);
  create index idx1 on two (alias);
  create index acos_idx3 on three (model, related_id);
  </code></pre>