Monday, May 16, 2011

how to change data dir of mysql

It is very easy.  You just move /var/lib/mysql to where you want and edit this property "datadir" in mysql config file /etc/mysql/my.cnf.