var directory too small to hold all the MySQL databases, will this solution work?
Discussion in 'General Discussion' started by jols, Sep 19, 2008.
And the databases in /var are growing every day. The /var directory will probably fill up to 100% early next week.
Any problem with that for a solution?
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.
Thanks Chirpy. Another question about this: So I suppose a regular account CP-restore will work as well under this circumstance?
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.
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??