Page 1 of 1

mysql partitioning

Posted: Thu Apr 05, 2007 10:11 am
by GeXus
When doing partitioning, I understand how to create the partitions (sort of)... but how do you specify what disk a partition resides on?

Thanks!

Posted: Thu Apr 05, 2007 7:56 pm
by califdon
You are posting in a Databases forum. Partitioning is an Operating System issue.
:evil:

Posted: Thu Apr 05, 2007 8:06 pm
by Benjamin
You can move the folder containing the mysql data files to a different partition and create a symbolic link pointing to the new location. Be sure to stop MySQL during this operation and ensure that the permissions stay the same.