List:General Discussion« Previous MessageNext Message »
From:rich allen Date:January 3 2003 6:03pm
Subject:Re: changing database location
View as plain text  
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?

Thread
changing database locationaman raheja3 Jan
  • Re: changing database locationrich allen3 Jan