/var overload problem

l0rdphi1

Verified User
Joined
Jun 22, 2003
Messages
1,471
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! :p, oh and another bonus: databases would count towards a user's storage quota

Good idea? ( ETA? :D )
 
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 :D

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
 
Back
Top