title: MySQL : how to divide database into two disks?
body: <p>I have a database installed in C:\ and I created an other database in C:\ to log users' data because the data size is very big, So I want to save it somewhere else.</p>
  <p>Then I moved the second database with its data to D:\ through a <strong>symbolic link</strong> file to point out the new directory.</p>
  <blockquote>
  <p>Here the file name : archive_file.sym</p>
  <p>And here its content : D:\MySQLData\data\archive_db</p>
  <p>archive_db : is the name of my second database</p>
  </blockquote>
  <p>the problem is when I executed a MySQL command to see the content of one of the tables in the seconde database:</p>
  <blockquote>
  <p>use 'archive_db';</p>
  <p>select * from 'log_user';</p>
  </blockquote>
  <p>I've got this error :</p>
  <blockquote>
  <p>'log_user' Table doesn't exist</p>
  </blockquote>
  <p>I've tried symbolique_link throughout MySQL documentation :
  <a href="http://dev.mysql.com/doc/refman/5.0/en/windows-symbolic-links.html" rel="nofollow noreferrer">Using Symbolic Links for Databases on Windows</a>.</p>
  <p>Any advices ? Any idea how to proceed otherwise?</p>
  <p>I'm working on Windows server 2008-r2 , MySQL server version 5.6</p>