title: Setting up multiple MySQL databases with different data directories
body: <p>So I've been trying to find a way to locate 2 databases within different directories.</p>
  
  <p>The reason I want to do this, is because I have a relatively small database that hardly changes, that I want to locate on the local drive of the server. The other database is ever changing, and so I want to locate it on my SAN. But, I want to control both from the same MySQL server.</p>
  
  <p>I know how to change the default data directory, by doing something along the lines of <a href="https://stackoverflow.com/questions/1795176/how-to-change-mysql-data-directory">this</a>  </p>
  
  <p>And, after searching through google, it seems that it can only be done by setting up multiple instances, each with their own default data directory.</p>
  
  <p>Have I missed something?</p>