Hi,
I want to change the default MySQl directory so that MySQl data is stored on /home/mysql/ instead of /var/lib/mysql
I am thinking about the following
1) Create /home/mysql
2) copy content of /var/lib/mysql to /home/mysql
3) delete /var lib/mysql
4) create symbolic link from /home/mysql to /var/lib/mysql
Does anyone know if this would work OK, or if I have missed anything out ?
any better ways of achieving the same ?
Thanks in advance
I want to change the default MySQl directory so that MySQl data is stored on /home/mysql/ instead of /var/lib/mysql
I am thinking about the following
1) Create /home/mysql
2) copy content of /var/lib/mysql to /home/mysql
3) delete /var lib/mysql
4) create symbolic link from /home/mysql to /var/lib/mysql
Does anyone know if this would work OK, or if I have missed anything out ?
any better ways of achieving the same ?
Thanks in advance