My dev mysql service stopped working suddenly ... the logfile shows an error message:
Disk is full writing './binlog.000558' (OS errno 28 - No space left on device). Waiting for someone to free space... Retry in 60 secs. Message reprinted in 600 secs.
Unfortunately this happend in a vagrant / virtualbox setup and I had problems with the whole server, which could not start or halt with an errormessage which leaded to ntfs or ssh connection errors (No log for this errormessages :(
The solution was:
- Shut down the host system.
- Go, drink some coffee ...
- Start up the host
- Start up the vagrant machine
- Then login as root in mysql ...
mysql >
mysql > SHOW BINARY LOGS;
mysql -> PURGE BINARY LOGS BEFORE '2023-09-19 22:00:00';
The date value was yesterdays date. At least, this got me to run the vagrant machine again and secure some stuff before I destroyed the whole machine to set it up again.