MySQL disk Space count report
The MySQL installation folder is at C:\Program Files\MySQL\MySQL Server 5.7
the folder that contains the data is in C:\ProgramData\MySQL\MySQL Server 5.7\Data
This is the configuration that is installed in Windows Server 2019 by default.
I remember a long time ago in the first versions of Websitepanel this worked correctly, from a later version the space count stopped working.
That is if currently when a database is created it is created perfectly in the right place, as well as the user without any problem.
I also have to say that the exact same problem also occurs with SQL
Here is a related thread from over five years ago: https://solidcp.com/forum/question/disk-space-report/
Back then, I found that "MySQL installation folder" is really asking for the folder that contains the data folder. I don't think SolidCP needs to find the MySQL executables.
In that thread, Marco stated "I do think the whole space and bw calculation can use a revamp" and I don't know if any revamp has occurred.
Our disk space and bandwidth reports in SolidCP are still missing a lot of data (especially email disk space which is a big deal for some users), but I haven't tried to figure out if the exact behavior still matches what I reported five years ago.
Unfortunately, if I change the Installation folder to point at the Data folder, the manual backups do not work as they can't find the .exe files. This is the error we get when:
That setting 100% needs to point at the Installation folder and not the Data folder so we are still stuck!
I'm v1.4.8 we released a method of using a remote MariaDB 10.3+ database. This has a change of method to calculate the disk space rather than trying to always read the files.
For MySQL we look at the my.ini in the installation path for the datadir path. We then use this path to access the files and calculate the size.