/var overload problem

[l0rdphi1]

Since DA stores SQL databases in /var/lib/mysql my /var partition filled up fairly fast. In order to correct this I symlinked /var/lib/mysql to /home/mysql. Fixes problem.

BUT, wouldn't it be nice if DA stored databases in /home/{username}/mysql? You'd simply create links from /var/lib/mysql/{database} to /home/{username}/mysql/{database}.

It'd be great! , oh and another bonus: databases would count towards a user's storage quota

Good idea? ( ETA? )

 

[DirectAdmin Support]

Hello,

It would solve issues for small /var partitions, yes. As for quotas
a) its not owned by the user, it's owned by mysql, so system quotas won't find it.
b) they're already included when DA tallies everything

I think it would just be easiest to move the whole mysql directory... that way all new db's will be in the right spot.

John

 

[l0rdphi1]

Oh, I see. I didn't know they were already being counted.

Thanks