homepage Welcome to WebmasterWorld Guest from 54.205.99.71
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Hardware and OS Related Technologies / Linux, Unix, and *nix like Operating Systems
Forum Library, Charter, Moderators: bakedjake

Linux, Unix, and *nix like Operating Systems Forum

    
Flushing mysql logs
asantos




msg:3971447
 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?

 

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Hardware and OS Related Technologies / Linux, Unix, and *nix like Operating Systems
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved