Forum

MySQL disk Space co...
 
Notifications
Clear all

MySQL disk Space count report

Page 3 / 4

tonyd
Posts: 11
Topic starter
(@tonyd)
Active Member
Joined: 2 months ago

Hello,

my.ini is correct for the datadir path.

part of my.ini:

# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this
# file.
#
# server_type=2
[mysqld]

# The next three options are mutually exclusive to SERVER_PORT below.
# skip-networking

# enable-named-pipe

# shared-memory

# shared-memory-base-name=MYSQL

# The Pipe the MySQL Server will use
# socket=MYSQL

# The TCP/IP Port the MySQL Server will listen on
port=3306

# Path to installation directory. All paths are usually resolved relative to this.
# basedir="C:/Program Files (x86)/MySQL/MySQL Server 5.7/"

# Path to the database root
datadir=C:/ProgramData/MySQL/MySQL Server 5.7\Data

# The default character set that will be used when a new schema or table is
# created and no character set is defined
character-set-server=utf8

Reply
indexebusiness
Posts: 34
(@indexebusiness)
Eminent Member
Joined: 5 years ago

Ah ha!  Thank you @trobinson for that piece of information as that has helped me fix our problem. 

We upgraded MySQL to MariaDB a while ago and as part of the upgrade the MariaDB Service still uses the old MySQL location for it's my.ini file.

The command line of our MariaDB service was:

"C:\Program Files\MariaDB 5.5\bin\mysqld.exe" "--defaults-file=C:\Program Files\MySQL\MySQL Server 5.5\my.ini" "MySQL55"

So to fix it we copied the my.ini file from the old location to the MariaDB location and updated the MariaDB service in the Registry. We also had to restart the Scheduler service and after that the Disk Space calculation is fully working!

Hopefully this will help someone else.

Regards

Mark

Reply
Trevor Robinson
Posts: 1412
Admin
(@trobinson)
Member
Joined: 6 years ago

@tonyd Can you check on the server itself in Windows Event viewer -> Applications -> SolidCP if there is any error logged?

@indexebusiness Can you confirm for me which version of SolidCP you are using?

Reply
1 Reply
indexebusiness
(@indexebusiness)
Joined: 5 years ago

Eminent Member
Posts: 34

Hi @trobinson 

Sure no problem, we have the latest release 1.4.8 on all of our servers.

If you need anything else let me know.

Reply
tonyd
Posts: 11
Topic starter
(@tonyd)
Active Member
Joined: 2 months ago

Hola, El registro de eventos de SOLIDCP en los eventos de Windows está en blanco, sin errores. La versión de SOLIDCP es la última 1.4.8 instalada desde 0.

We also have the same problem with SQL, on the same server, however the database registrations are carried out automatically without any problem.

Reply
tonyd
Posts: 11
Topic starter
(@tonyd)
Active Member
Joined: 2 months ago
Hello, SOLIDCP event log in Windows events is blank, no errors. SOLIDCP version is latest 1.4.8 installed from 0.

We also have the same problem with SQL, on the same server, however the database registrations are carried out automatically without any problem.
Reply
Page 3 / 4
Share:
Downloads

Login

Lost your password?

Create an account?