I don’t know if it’s a host level decision or if it’s a matter of defaults in Linux, but it seems my current host likes to put the MySQL files in
/var/lib/mysql
Which is pretty standard. My problem is, most hosts seem to make /home the big partition and then leave /var very small in comparison.
So I have to go in, shut down MySQL, move it to /home, then symlink it and restart MySQL. I wish more hosts would move all files related to a domain into the domain folder itself. I know some clients may trip all over themselves and delete these files but they have to learn sometime.
So far, 5 out of 5 machines with various control panel software have all been this way. I should also mention that these are dedicated servers, so maybe the expect whoever gets the box will tweak it to suit their needs, but in this day and age, just about everything is stored in a database and that’s where the majority of file space is used. Put it on the big partition in the future, if you don’t mind.





