mysql partitioning

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

mysql partitioning

Post 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!
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Post by califdon »

You are posting in a Databases forum. Partitioning is an Operating System issue.
:evil:
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Post 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.
Post Reply