Why doesn't cpanel store the mysql databases along with the cpanel settings inside the user's home directory ? It would be better in my opinion.
Why doesn't cpanel store the mysql databases along with the cpanel settings inside the user's home directory ? It would be better in my opinion.
WireNine ● In business since 2004.
Shared, Reseller cPanel/WHM Hosting
R1Soft Backups, LiteSpeed, RVSiteBuilder, Softaculous and RVSkin
I suppose it would be more correct in theory but I would hate to deal with a manual restore of databases through hundreds of users that way. Sure you can run scripts and place it, etc... But, I prefer zipping up the /var/mysql directory as a whole and dump it on another server for a move or backup. The same holds true for cpanel settings.
I am sure there are many other reasons but that horror just went through my mind when I read your post.
Also when the database size increases, the quota issues will occur regularly.