From: rich allen Date: January 3 2003 6:03pm Subject: Re: changing database location List-Archive: http://lists.mysql.com/mysql/128959 Message-Id: MIME-Version: 1.0 (Apple Message framework v551) Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit 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?