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 standard in Oracle Set-Ups. Let me know if this works or if
you find a better way (I have some MySql work coming up where I need to
store more data than 1 partition as well....)
Obviously, I would backup the data and have MySQL off when trying this.
Eric
http://www.dlcwest.com/~jed/re_answer.shtml
Cecil Watson wrote:
>
> 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
