Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
GeXus
Forum Regular
Posts: 631 Joined: Sat Mar 11, 2006 8:59 am
Post
by GeXus » Thu Apr 05, 2007 10:11 am
When doing partitioning, I understand how to create the partitions (sort of)... but how do you specify what disk a partition resides on?
Thanks!
califdon
Jack of Zircons
Posts: 4484 Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA
Post
by califdon » Thu Apr 05, 2007 7:56 pm
You are posting in a Databases forum. Partitioning is an Operating System issue.
Benjamin
Site Administrator
Posts: 6935 Joined: Sun May 19, 2002 10:24 pm
Post
by Benjamin » Thu Apr 05, 2007 8:06 pm
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.