| Welcome to WebmasterWorld Guest from 126.96.36.199 |
register, login, search, subscribe, help, library, PubCon, announcements, recent posts, open posts,
|Subscribe to WebmasterWorld|
|Flushing mysql logs|
| 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).
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?
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld ® and PubCon ® are a Registered Trademarks of Pubcon Inc.
© Pubcon Inc. 1996-2012 all rights reserved