Re: changing database location

[rich allen]

shutdown mysql, move all the files in your current data directory to 
the new location

in your my.cnf file (ie. unix: /etc/my.cnf)

[mysqld]
datadir=/my

-------
all data files are in /my

- hcir

On Friday, January 3, 2003, at 07:56 AM, aman raheja wrote:

> Hi All
> Right now I have all my MySQL database files getting stored in
> /var/lib/mysql/
> If I want to change that to another location, say, /home/mysql or 
> something
> else, how do I do it?