What I do normally when a server would benefit from stuff residing on different spindles (i.e. physical disks), is to point the application to the location of the new data, if the app does support that, and copy everything to the new location. If it does not, then symlinks are an option.<br>
<br>Assuming /dev/sda is the first disk, and /dev/sdb is the second:<br><br># Partition the disk <br>fdisk /dev/sdb<br># Create a file system<br>mkfs -text3 /dev/sdb1<br># Mount as a new disk<br>mount /dev/sdb1 /disk2<br>
# Shutdown MySQL<br>/etc/init.d/mysql stop<br># Copy the data<br>cp -a /var/lib/mysql /disk2<br># Edit my.cnf to point to the new location<br>vi /etc/mysql/conf.d/local.cnf<br><br>A similar procedure can be followed for /home, by editing the /etc/passwd<br>
file and change /home to /home/disk2 or whatever.<br>-- <br>Khalid M. Baheyeldin<br><a href="http://2bits.com">2bits.com</a>, Inc.<br><a href="http://2bits.com">http://2bits.com</a><br>Drupal optimization, development, customization and consulting.<br>
Simplicity is prerequisite for reliability. -- Edsger W.Dijkstra<br>Simplicity is the ultimate sophistication. -- Leonardo da Vinci<br>