Thanks to all of you who replied. Yves
On Wed, 3 Nov 2004 13:57:33 +0000 (GMT), andy thomas <[EMAIL PROTECTED]> wrote: > On Wed, 3 Nov 2004, Yves Arsenault wrote: > > > Thanks for the reply, > > > > Is there any information on the mysql.com website on how to store data > > on 2 separate partitions? > > I'm not sure but you can use symbolic links to make databases in different > partitions appear to be under the one that mysql uses. For example, > suppose that on your system, the database DB_A is under /usr and database > DB_B is uder /var - mysql can see /usr/DB_A but not /var/DB_B. But if you > symbilically link /var/DB_B to /usr/DB_B with: > > ln -s /var/DB_B /usr/DB_B > > then mysql can see and use DB_B. Of course, you also need to be sure mysql > has permissions to read and write to DB_B in /var. > > Hope this helps, > > Andy > > > > > 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]
