Re: Dumping MySQL result set to a spreadsheet

2004-02-29 Thread Neale Banks
On Sun, 29 Feb 2004, Joshua Beall wrote: I am wondering if anyone can point me to a utility that will let me dump the result of a MySQL query to a file I can open in MS Excel or (preferably) OpenOffice.org Calc. [...] But before I spend any time working on doing that, I am wondering if

disabling wait_timeout?

2004-02-02 Thread Neale Banks
Can it be done? I tried to disable this timer with wait_timeout = 0 in my.cnf. That changed the timeout (as reported by mysqladmin variables) from the default 28800 to 1. Tested, it was definitely a one-second timeout :-( As a hack-around, I've currently got it set to ten days.