On Wed, 3 Nov 2004, Yves Arsenault wrote: > Hello all, > > I have MySQL installed on a Mandrake Linux system, it is installed on > the /usr partition. > > I was wondering, is it possible to store some databases on the /var > partition while MySQL is installed on the /usr partition?
Yes. In fact, somewhere under the /var tree is the usual place for mysql databases to reside in many installations. > And, if it is possible, can you store DB_A on /usr and DB_B on /var > (or at least 2 different partitions). You can although current thinking in the UNIX/Linux world is that the /usr filesystem should be read-only, which means files & directories that change all the time shouldn't be under /usr. But older UNIXes and Linuxes commonly use /usr/var, /usr/tmp and /usr/var/tmp for holding changing data so it's really up to you. If the databases are big and/or heavily used, I tend to put them on their own /mysql partition or even on their own fast disk. /home/mysql or /export/home/mysql is another possibility. Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
