Thanks for the reply, Is there any information on the mysql.com website on how to store data on 2 separate partitions?
I'll be doing a bit of research on this soon... Thanks again, Yves On Wed, 3 Nov 2004 13:21:59 +0000 (GMT), andy thomas <[EMAIL PROTECTED]> wrote: > 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 > > -- Yves Arsenault -- Yves Arsenault -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]