cPanel/WHM

Hi all,

I have critical problem on my linux box. I have Red Hat Linux/WHM installed server and I have /var partition of the size 10 GB. Now, /var is near to reach its allocated space and I am storing the mysql databases at /var/lib/mysql (i think it a default location of mysql database). Is it posisble to move mysql databases to other location instead of /var/lib/mysql/ ?

Thanks,

Mike

Hi Mike,

it is possible to move your mysql databases to other location. Just follow the below steps:

- Stop mysql service.
- Move your databases to other location.
- Change the path of your mysql database directory in my.cnf (probably it is in /etc) file.
- Start MySQL service.

Or you can just create a symlink /var/lib/mysql to point to new location.

John