back to a "roomier" /home directory.
Thanks,
Dennis Williams
- Original Message -
From: "Trevor Forrester" <[EMAIL PROTECTED]>
To: "DWilliams" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, December 31, 2001 12:59 AM
Subject: RE
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
uot; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, December 30, 2001 3:29 PM
Subject: Re: MySQL RPM Install Problem - Ignorance
> At 14:37 -0600 2001/12/30, DWilliams wrote:
> >Robert,
> >
> >Thanks for the tips...
> >
> >>>1. create
At 14:37 -0600 2001/12/30, DWilliams wrote:
>Robert,
>
>Thanks for the tips...
>
>>>1. create a symlink at /var/lib/mysql that points to your data directory<<
>
>I had read that this was not the best way prior to v4.0, something about an
>"alter table" statement might ignore the symlink?
I've use
o this...but I opted for the RPM instead.
I guess that is why I have these sort of configuration difficulties.
Thanks again,
Dennis Williams
- Original Message -
From: "Robert Alexander" <[EMAIL PROTECTED]>
To: "DWilliams" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECT
Hi Dennis,
There's several ways you can move the datafile location:
1. create a symlink at /var/lib/mysql that points to your data directory
2. you can change or add the 'datadir' variable in your my.cnf file (usually
/etc/my.cnf) see: http://www.mysql.com/doc/C/o/Configuring_MySQL.html
3. you
