<div>
Please Refer:<br />
<a href="http://serverfault.com/questions/90207/how-to-save-a-mysql-database-on-another-drive" rel="ugc">http://serverfault.com/questions/90207/how-to-save-a-mysql-database-on-another-drive</a><br />
<a href="http://dev.mysql.com/doc/refman/5.0/en/windows-symbolic-links.html" rel="ugc">http://dev.mysql.com/doc/refman/5.0/en/windows-symbolic-links.html</a>
</div>


Please Refer:
http://serverfault.com/questions/90207/how-to-save-a-mysql-database-on-another-drive [http://serverfault.com/questions/90207/how-to-save-a-mysql-database-on-another-drive]
http://dev.mysql.com/doc/refman/5.0/en/windows-symbolic-links.html [http://dev.mysql.com/doc/refman/5.0/en/windows-symbolic-links.html]

<div>
Thank you, my bad, I failed to indicate that I am using <br />
innodb_file_per_table option (the only way with many large databases like mine).<br />
The second article indicates that .sym files are not supported in this mode.<br />
Any other options in Windows?
</div>


Thank you, my bad, I failed to indicate that I am using
innodb_file_per_table option (the only way with many large databases like mine).
The second article indicates that .sym files are not supported in this mode.
Any other options in Windows?

<div>
<div class="content wysiwyg-content">
I would like to use multiple data directories. &nbsp;Right now my.ini points to a single d:\mysqldata directory.<br />
I would like to do something as in Microsoft SQLServer that allows storing database files anywhere (e.g. d:\sqldata, e:\sqldata, f:\sqldata).<br />
<br />
Why? &nbsp;I have <b>many</b> large (5Gb+) mySQL databases. &nbsp;SSD is the way to go, but drives bigger than 128G are for now expensive. &nbsp;Plus a single point of failure for all the databases...<br />
So I would like to add 128G SSD drives in my Windows machine, as I do in my SQL Servers.
</div>
</div>


I would like to use multiple data directories.  Right now my.ini points to a single d:\mysqldata directory.
I would like to do something as in Microsoft SQLServer that allows storing database files anywhere (e.g. d:\sqldata, e:\sqldata, f:\sqldata).

Why?  I have many large (5Gb+) mySQL databases.  SSD is the way to go, but drives bigger than 128G are for now expensive.  Plus a single point of failure for all the databases...
So I would like to add 128G SSD drives in my Windows machine, as I do in my SQL Servers.

multiple mySQL data directories?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.