Friday, February 27, 2009

MySQL tip - logging results in a file

While using a mySQL command line client has it ever happened that you fire a query and the result runs into pages scrolling your entire command line. Obviously you need some better way to view the results. probably redirecting result to a file would help.

Naah! traditional redirection operator does not work. Instead use this mysql> tee c:/result.txt

Thats it......
After this command everything you do on your client window will be logged into the file c:/result.txt

Its for your command line session obviously. For the next session, repeat the activity.

Disclaimer: Anything can be found on google. I just jot it down here again because this acts my repository. And yeah! I have a better memory if I write down things ;)

No comments: