var directory too small to hold all the MySQL databases, will this solution work?

Yes, It will work without any problem.

 

Do NOT forget to stop MySQL service before you start moving the data otherwise there is a chance that the database might be corrupted.

Kailash

 

In the past you also had to add the following directive to /etc/my.cnf otherwise the cPanel backups won't backup the entire mysql database correctly (if you have that set):

datadir=/home/mysql

 

Can anyone confirm if this is still required?

 

I haven't had to use it, but you could always try it without, if it doesn't work the you may need to add the line.

Also, prior to stopping mysql you should stop checksrvd first, otherwise it will restart mysql after a short period which could screw up the copying of the mysql files etc.

 

linux thirst

Hello ,

Yes, this is optionally required because even then you have created the sym link means the data will be available from both dir

 

sorry to dig this post but according to other forum, the setting of datadir in my.cnf is required (not optional) because of the cpanel backups.

Can someone from cPanel here confirm that if I symlink /var/lib/mysql to /home/mysql it will still backup the "Per account and entire mysql directory" using cpbackup??

 

can someone from cPanel answer this for me please??

 

search the forums; there is a detailed post with all steps needed to change the /mysql location

I've done that and moved to /home/mysql and all works just fine: backup, space count into cpanel and had no problem for about one month now

I'll try to find for you, too bad I didn't marked

 

founded

http://forums.cpanel.net/f5/move-mysql-databases-6655.html


only one mention:

I had to change owner for /home/mysql folder cause I wasn't able to start mysql

so just before mysqld start execute

chown -R mysql:mysql /home/mysql

good luck