Change mysql database directory

[Kailash1]

Hi,

I have stored Mysql database in /var/lib/mysql location and now /var is about to reach its allocated space. Is there any way I can change the location and move the existing Mysql databases to new location?

Thanks,

Kailash

[cPanelDavidG]

Hi,

I have stored Mysql database in /var/lib/mysql location and now /var is about to reach its allocated space. Is there any way I can change the location and move the existing Mysql databases to new location?

Thanks,

Kailash

This thread may help: http://forums.cpanel.net/showthread.php?t=71424

That thread also links to another thread that may help.

[Marty]

cd /var/lib

service chkservd stop

service mysql stop

mv mysql /home

ln -s /home/mysql mysql

service mysql start

service chkservd start

That is the way I do it. Use at your own risk. I think I have ln -s command correct.

[Kailash1]

Thanks David and Marty.

And sorry for the duplicate post.

Kailash

[Kailash1]

Will it create any problem taking cPnel backup (including MySQL databases) after changing the location of MySQL databases.

Thanks,

Kailash

[Marty]

Will it create any problem taking cPnel backup (including MySQL databases) after changing the location of MySQL databases.

Thanks,

Kailash

No, the backups will follow the symlink, so there is no problem at all.

[Kailash1]

Thanks Marty,

Kailash

[jugo]

Worked for me....

Thanks.