t;[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.
:~>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 t
I guess a quick manual way would be move the files to another partition
and create symbolic links to the new files in their original location.
If you go this route, you'll probably get even better speed if you can
have the indexes and tables on separate physical disks. This is pretty
much the st
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