Remove/truncate large log file

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Remove/truncate large log file

Postby petersrq » 05. May 2021 19:45

Hi All,

what is the best (safest) way to clear/truncate/delete logs in MySQL folder? One of my log files has 33GB (!!!) of data!

Image
petersrq
 
Posts: 1
Joined: 05. May 2021 19:38
XAMPP version: 1.7.3
Operating System: Windows

Re: Remove/truncate large log file

Postby Altrea » 05. May 2021 22:17

Hi,

To savely remove the mysql_general Log file while running, you need to disable the general log temporarily:
Code: Select all
SET GLOBAL general_log = 'OFF';


After deleting the file you can reenable the general log again
Code: Select all
SET GLOBAL general_log = 'ON';
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 89 guests