Thanks for the suggestion. Here is what I did.
Stopped MySQL /etc/rc.d/init.d/mysql stop
Made a new data directory.
Copied databases to the new directory.
Check make sure permissions are the same and in the old directory.
Edit /etc/rc.d/init.d/mysql (changed datadir=/var/lib/mysql to the new
directory). Note if you installed via source I believe you'd locate my.cnf
(should be under /etc) and make the change there.
Started MySQL /etc/rc.d/init.d/mysql start
:-)
Say...How can I find what files have been added to my system recently?
----- Original Message -----
From: Denis HAVLIK <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 02, 2000 5:46 PM
Subject: Re: [expert] Changing the location of a MySQL db?
> :~>Is it possible to change the location of a MySQL DB? I have one that
has
> :~>eaten most of my space on /dev/sda5 my /var. How can I change the
location
> :~>of a db on /var/lib/mysql and have MySQL create new other databases in
> :~>another location? Thanks in advance,
> :~>
> :~>Cecil
> [short]
> take the directory with database and move it to some other partition. Then
> mount this other partition to the place where these data used to be, and
> DB will not even notice that anything has changed. And stop thinking in
> windows terms .-)
>
> cu
> Denis
> --
> -----------------------------------------------------
> Dr. Denis Havlik <http://www.ap.univie.ac.at/users/havlik>
> Mandrakesoft ||| e-mail: [EMAIL PROTECTED]
> Quality Assurance (@ @) (private: [EMAIL PROTECTED])
> -------------------oOO--(_)--OOo---------------------
> Hi! I'm a .signature virus! Copy me into your ~/.signature to help me
> spread! ([EMAIL PROTECTED])
>
