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