Reduce space of bin files in MariaDB

Whenever binary logs are taking up too much disk space in a SCP installation, there’s the possibility to free up some space.

In order to do that, there’s a set of instructions that need be followed:

  1. Open Powershell
  2. Go to Path C:\SCP\mariadb-10xx\bin
  3. Type .\mysql -uroot oat and press Enter key
  4. Type start and press Enter Key
  5. Type PURGE BINARY LOGS BEFORE ‘2021-02-01 00:00:00 (this date is merely an example, a different date can be set, as long as the syntax is the same) and press Enter Key

The files should be purged and then the Powershell window can be closed

Copyright OM Digital Solutions. All Rights Reserved