Re: Separate dbs on separate partitions?

2002-09-09 Thread Michael T. Babcock
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

Separate dbs on separate partitions?

2002-09-07 Thread hudson kingery
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

Separate dbs on separate partitions?

2002-09-07 Thread hudson kingery
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

Re: Separate dbs on separate partitions?

2002-09-07 Thread Paul DuBois
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