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

[jols]

Currently using:
WHM 11.23.2 cPanel 11.23.6-R27225
REDHAT Enterprise 5.2 i686 on standard - WHM X v3.1.0

Our /var directory is over 90% full, even though the /home directory is less than half full. This is due to all the large databases being kept by the hosted accounts in /var/lib/mysql

And the databases in /var are growing every day. The /var directory will probably fill up to 100% early next week.

Okay, so how about if we solve this using a symlink, like this?:

mv /var/lib/mysql /home/mysql
ln -s /home/mysql /var/lib/mysql

Any problem with that for a solution?

Thanks much.

 

[ashokpomnar]

Yes, It will work without any problem.

 

[Kailash1]

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

 

[chirpy]

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

 

[jols]

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

Thanks Chirpy. Another question about this: So I suppose a regular account CP-restore will work as well under this circumstance?

 

[Website Rob]

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?

 

[rachelm]

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.

 

[Ghulam Yaseen]

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

Can anyone confirm if this is still required?

 

[sharmaine001]

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??

 

[sharmaine001]

can someone from cPanel answer this for me please??

 

[discovery]

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

 

[discovery]

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