On Sat, Jul 28, 2012 at 3:22 PM, Ramnarayan.K <ramnaraya...@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. -- ubuntu-in mailing list ubuntu-in@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-in