Dennis if you want to see if the /var/lib/mysql directory is on it's own
partition or drive look at /etc/fstab and see which /dev it is mounted on.
If you wanted to you can mount a new drive at /var/lib/mysql and have you
data on it's own drive. If you have some sort of system failure you can just
mount the drive on a new installation using the /etc/fstab file.

Some people mount there individual databases on standalone drives. Not
saying this the best way but it is one way if you can afford hardware. That
leaves you root drives for programs.

Regards
Trevor
-----Original Message-----
From: DWilliams [mailto:[EMAIL PROTECTED]]
Sent: Monday, 31 December 2001 2:56 AM
To: [EMAIL PROTECTED]
Subject: MySQL RPM Install Problem - Ignorance


Hi all,

I have recently installed a MySQL server and client RPM 3.23.47 on a Linux
system.  The system that I am setting up is a Cobalt RAQ4, first time for me
to install MySQL on Linux.

The installed datadir turned out to be /var/lib/mysql.  I get errors when
trying to move a very large MySQL data (800MB) directory from a previous
host system.  It turns out that the /var directory has it's own partition, I
think.  A 'df' command shows not enough room on the /var directory for the
MySQL data files.

I am thinking I need to change the datadir variable to somewhere on the
/home directory, where I have > 15GB free.

How can I achieve this?  Or is this the right approach?  I think I
understood that the server can be started up with a different --datadir
option, but I would like this to be more permanent in case of system
reboots.

Thanks,
Dennis Williams


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to