Page is a not externally linkable
- Hardware and OS Related Technologies
-- Linux, Unix, and *nix like Operating Systems
---- Flushing mysql logs


asantos - 7:01 pm on Aug 13, 2009 (gmt 0)


Hi, i activated the Slow Query Log to check for some issues a few weeks ago and now i want to delete the contents of this file (is way to big 270mb).

I've tried:
mysqladmin -u myuser -p flush-logs

...but it returns a "you need the RELOAD priviledge for this operation" message.

I've also tried using -u root but it doesnt seem to have the necesary permisions to connect to mysql (odd?)

What can i do to flush this file without stopping the mysqld service?


Thread source:: http://www.webmasterworld.com/linux/3971445.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com