See the FAQ; but basically, use symlinks.

/var/mysql/database1 -> /disk1/database1
/var/mysql/database2 -> /disk2/database2

... or just mount /var/mysql/database1 as another partition.

/etc/rc.d/init.d/mysql stop
cd /var/mysql
tar -czf database.tar.gz database1
rm -rf database1
mkdir database1
mount /dev/sda2 database1
tar -zxf database.tar.gz
/etc/rc.d/init.d/mysql start

hudson kingery wrote:

> I would like to make use of multiple physical drives.
> Is there a way to have one mysqld but have databases on separate 
> partitions?

-- 
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to