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
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
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
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