[ubuntu-in] mysql database files

[Mehul Ved]

On Sat, Jul 28, 2012 at 3:22 PM, Ramnarayan.K <ramnarayan.k at gmail.com> wrote:
> A different question arising out of Alok's trouble so am Top Posting
>
> is it possible to store mysql and other database files in a location other
> /(root) if so where and how would it need to be done

You need to change the datadir option in /etc/mysql/my.cnf e.g. if you
want to store files in /home/user/mysql/ then

-----my.cnf-----
datadir=/home/user/mysql

Read http://askubuntu.com/questions/137424/moving-mysql-datadir for
further instruction on how to move already existing files.