Re: Separate dbs on separate partitions?
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
Separate dbs on separate partitions?
I would like to make use of multiple physical drives. Is there a way to have one mysqld but have databases on separate partitions? OS is linux. Thanks Hudson - 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
Separate dbs on separate partitions?
I would like to make use of multiple physical drives. Is there a way to have one mysqld but have databases on separate partitions? OS is linux. Thanks Hudson - 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
Re: Separate dbs on separate partitions?
At 16:58 -0400 9/7/02, 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? Shut down the server. Copy the database directory to the other drive Make a symlink to the moved directory in the server's data directory Restart the server Doesn't work for InnoDB tables, which are managed in the InnoDB tablespace. OS is linux. Thanks Hudson - 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 - 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